Item separator by a line break from select statement

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!

Like this:

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.

See also:

2 Likes

It works great, thank you for your quick response Steve!

2 Likes