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)