How do I insert a line break when using the CONCATENATE function?

[ShaneRuth]

I want to combine text into a single cell but I want the text to be stacked
vertically not in a line.

 

[Tom Hayakawa]

Use char(10).

Example:

=CONCATENATE("How",CHAR(10),"now,",CHAR(10),"brown cow?")

Good luck,

Tom Hayakawa

 

[Gord Dibben]

Shane

=A1 & CHAR(10) & A2 & CHAR(10) & A3......on and on

Format to "wrap text"

Gord Dibben Excel MVP