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

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