Inserting line breaks in text formula


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

Advertisements

D

David McRitchie

=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...
 
G

Guest

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top