Hey folks, is there any way of separating text values by line break from list select statement? I want the items in the virtual column called test to be separated by line breaks as it is in the second picture. I also need these items to be separated by new lines in my generated word document so that’s why I’ve created the extra virtual test column. Thanks!
SUBSTITUTE(SELECT(...), ",", " ")
Note carefully that the first line ends with a quote mark and the second line begins with a quote mark. The second line should not be indented–it should be flush against the left edge of the expression-editing window.
It works great, thank you for your quick response Steve!