Solved: Item separator by a line break from select stateme... - Page 2

richard_s · 03-02-2021 06:39 AM

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!

→

Steve

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.

Item separator by a line break from select statement