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

S

ShaneRuth

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

Tom Hayakawa

Use char(10).

Example:

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

Good luck,

Tom Hayakawa
 
G

Gord Dibben

Shane

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

Format to "wrap text"

Gord Dibben Excel MVP
 
Top