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)

=A2&CHAR(10)&D2

Biff

"Max" <Max@discussions.microsoft.com> wrote in message
news:E1236071-E0AA-4002-94D2-D6BDD51C00AD@microsoft.com...
> 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)

Max

=A2&CHAR(10)&A5


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 20:56:01 -0800, Max <Max@discussions.microsoft.com> 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)

Max

=A2&CHAR(10)&A5


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 20:56:01 -0800, Max <Max@discussions.microsoft.com> 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)