| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting line breaks in text formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting line breaks in text formula
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting line breaks in text formula
=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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting line breaks in text formula
=A1 & CHAR(10) & B1 & CHAR(10) etc.
Gord Dibben MS Excel MVP On Sat, 29 Sep 2007 18:52:00 -0700, 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. Any ideas? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting line breaks in text formula
Thanks, that works - I seen this before, but had completely forgotten....
-- J M Shelton "David McRitchie" wrote: =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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting line breaks in text formula
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove line breaks in text strings | New Users to Excel | |||
| inserting an additional line of text within same cell | Excel Worksheet Functions | |||
| Can you get line breaks in a text cell | Excel Discussion (Misc queries) | |||
| Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
| Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
