concatenate and insert carriage return to separate entries

[MAJR]

Hi all, i would like to use Concatenate to merge text from several cells. I need to separate the first text from the second and the third, basically having each text on its own line. Is this possible?
Thanks.
mr

[Paul]

You can use TEXTJOIN to concatenate the cell values, and use CHAR(10) as the delimiter. Make sure 'Wrap Text' is turned on for the cells with the formulas. Example:

Please Login or Register  to view this content.