=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?