Concatenate rows or columns with carriage return or line feed

To output data to indesign I need in a table that needs for some cells data on 2 lines, with a carriage return. I am concatenating columns, but I cannot find how to use a carriage return, \n does not work.
I could not find this information in the online help…
How can I do this?
Thank you in advance!



One way to do it is to use Substitute. For example to concatenate column 1 and column 2 with a carriage return between:

1 Like

Thank you!
I did not think of that.