| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert a line feed in a formula?
If you wish to copy and paste the concatenated result into an email body and
not loose the line returns try this. =CONCATENATE($A1,CHAR(13),$B1) Good luck. "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
