You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"J M Shelton" wrote in message
...
Thanks, that works - I seen that before, but couldn't remember it....
--
J M Shelton


"T. Valko" wrote:

Try it like this:

=A1&CHAR(10)&B1&CHAR(10)&C1

Format the cell to wrap text


--
Biff
Microsoft Excel MVP


"J M Shelton" wrote in message
...
I'm trying to insert a line break in a cell that has a formula that
joins
(using "&") text from other cells. I have cells for address, city, and
zip
and would like to create a new cell that has them all joined, but with
line
breaks.
Any ideas?


--
J M Shelton