How do I start new line when concatenating text strings in excel?
 

How do I add a command to start a new line when concatenating text strings in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)

How do I start new line when concatenating text strings in excel?
 

=A2&CHAR(10)&D2

Biff

"Max" wrote in message
...
How do I add a command to start a new line when concatenating text strings
in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)

How do I start new line when concatenating text strings in excel?
 

Max

=A2&CHAR(10)&A5


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 20:56:01 -0800, Max wrote:

How do I add a command to start a new line when concatenating text strings in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)