Thread: How do you embed a new line in a formula similar to &" "& but
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
  
Posts: 611
Default 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 With QuoteReply With Quote