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

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

Use char(10).

Example:

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

Good luck,

Tom Hayakawa

"ShaneRuth" wrote:

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

Shane

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

Format to "wrap text"

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 11:09:02 -0800, ShaneRuth
wrote:

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