How do I insert a line break using a formula (e.g when concatenat.
 

I'm concatenating values from multiple cells into a single cell and want to
put a line break in between them so as instead of getting e.g.
Mary,Tom, Ted
they appear as follows within a single cell:
Mary
Tom
Ted

I know I can do this manually using CTRL+carriage return but how can I do it
within my formula?

How do I insert a line break using a formula (e.g when concatenat.
 

=A1&CHAR(10)&A2&CHAR(10)&A3
Remember to format the cell to allow word wrap.

Are you sure you mean "CTRL+carriage return" and not Alt-Enter?
--
David Biddulph

"blustripes" wrote in message
...
I'm concatenating values from multiple cells into a single cell and want
to
put a line break in between them so as instead of getting e.g.
Mary,Tom, Ted
they appear as follows within a single cell:
Mary
Tom
Ted

I know I can do this manually using CTRL+carriage return but how can I do
it
within my formula?

How do I insert a line break using a formula (e.g when concatenat.
 

Your cell will need to be formatted as Wrap text.

=A1 & CHAR(10) & B1

Regards,
Paul

--

"blustripes" wrote in message
...
I'm concatenating values from multiple cells into a single cell and want
to
put a line break in between them so as instead of getting e.g.
Mary,Tom, Ted
they appear as follows within a single cell:
Mary
Tom
Ted

I know I can do this manually using CTRL+carriage return but how can I do
it
within my formula?