Inserting line breaks in text formula

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

 

[T. Valko]

Try it like this:

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

Format the cell to wrap text

 

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

 

[Gord Dibben]

=A1 & CHAR(10) & B1 & CHAR(10) etc.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks, that works - I seen that before, but couldn't remember it....

 

[Guest]

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

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

 

[T. Valko]

You're welcome. Thanks for the feedback!