| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I insert a line break when using the CONCATENATE function?
I want to combine text into a single cell but I want the text to be stacked
vertically not in a line. |
|
#2
|
|||
|
|||
|
Use char(10).
Example: =CONCATENATE("How",CHAR(10),"now,",CHAR(10),"brown cow?") Good luck, Tom Hayakawa "ShaneRuth" wrote: I want to combine text into a single cell but I want the text to be stacked vertically not in a line. |
|
#3
|
|||
|
|||
|
Shane
=A1 & CHAR(10) & A2 & CHAR(10) & A3......on and on Format to "wrap text" Gord Dibben Excel MVP On Fri, 5 Nov 2004 11:09:02 -0800, ShaneRuth wrote: I want to combine text into a single cell but I want the text to be stacked vertically not in a line. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Can I change the Insert Function button to an equals sign? | Excel Discussion (Misc queries) | |||
| Insert Function "FX" on Toolbar in Excel | Excel Discussion (Misc queries) | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Linear Mode
