Non-VBA Formula to include Carriage Return with Concatenate?

[javajoe]

Hey folks -

I have a series of cells with text in them. I want to use CONCATENATE to consolidate them into one cell, but separate each with a Carriage return. Is there a formula way to do this?

I know about vbCrLf but I'm looking for a formula-based solution if possible.

What I have is =A1&CHAR(13)&A2 but that doesn't actually display the two lines of text on their own lines.

Any ideas?

 

[Cbrine]

Use this instead
=A1&CHAR(10)&A2
and turn on the word wrap option for the cells.

HTH
Cal

 

[javajoe]

ah yes.... the word wrap setting. Thanks Cbrine!