Inserting line breaks in text formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=A2 & CHAR(10) & B2
You will also have to turn on Cell Wrap, with
Format (Ctrl+1), Cell, Alignment, [x] cell wrap
If you don't you will see square bullets denoting unprintable cells.

I hope you are creating this on a new sheet, because the result
would be very hard to work with in Excel.

If you are trying to print name and address labels, Excel is not well
suited for the task. You are expected to use MS Word with Excel
as the data base. See
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

When typing text into a cell use of Ctrl+Enter automatically
turns on Cell Wrap.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"J M Shelton" wrote...
 
Thanks, that works - I seen this before, but had completely forgotten....
--
J M Shelton


David McRitchie said:
=A2 & CHAR(10) & B2
You will also have to turn on Cell Wrap, with
Format (Ctrl+1), Cell, Alignment, [x] cell wrap
If you don't you will see square bullets denoting unprintable cells.

I hope you are creating this on a new sheet, because the result
would be very hard to work with in Excel.

If you are trying to print name and address labels, Excel is not well
suited for the task. You are expected to use MS Word with Excel
as the data base. See
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

When typing text into a cell use of Ctrl+Enter automatically
turns on Cell Wrap.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"J M Shelton" wrote...
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.
Click to expand...
Click to expand...
 
Back
Top