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

Make sure cell is set to wrap text.


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 09:53:01 -0700, leanjinja
wrote:



"Bretter99" wrote:

For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
put the result into a single excel cell like this:
I
LIKE
BEEF
BURGERS

But i cant see how to manually insert a line break into my statement as in
something like:
=concatenate(a1,<line break,a2,<line break,a3,<line break,a4,<line break,)
Any suggestions would be appreciated, thanks :P