Concatenate rows or columns with carriage return or line feed

Question
1

Hello,
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!

Best,

GLS

2

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

image
image786×374 31.2 KB

1 Like
3

Thank you!
I did not think of that.
Cheers
GLS