| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
First you need to turn on word wrap under formatcellsalignment, then use
CHAR(10), i.e. ="text"&CHAR(10)&"text2" Regards, Peo Sjoblom "TX_KniveS" wrote: I'm trying to insert a line feed (or carriage return) into a text formula I have in a cell. I'm trying to concatenate text entered into two other cells in this new cell and have the two entries on a different line within the same cell. Anybody know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I advance to next line when typing in the formula bar? | New Users to Excel | |||
| Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| insert a new row by formula | Excel Worksheet Functions | |||
| How do I insert a line break when using the CONCATENATE function? | Excel Worksheet Functions | |||
Threaded Mode
