| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you embed a new line in a formula similar to &" "& but
How do you embed a new line in a formula similar to &" "& but with a new line
instead |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you embed a new line in a formula similar to &" "& but
P,
="Line 1" & CHAR(10) & "Line 2" Have Wrap Text turned on (Format - Cells - Alignment) or you'll get a little square character for the newline. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "PMercierPM" wrote in message ... How do you embed a new line in a formula similar to &" "& but with a new line instead |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a formula so that it follows the sequence of line# | Excel Worksheet Functions | |||
| How do I get a line break when using a formula to combine cells | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Linear Mode
