Inserting line breaks in text formula
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
|