View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Symbol for new line in cell

CHAR(10)
--
David Biddulph

"James Silverton" wrote in message
...
Hello All!

This may be a dumb question but I've no idea how to do it. I need to enter
the new line character in a concatenation to get text on two lines in a
single cell. I know that if I were entering the data from scratch I would
use ALT+ENTER. Is there a symbol for this in Excel?

TIA
--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not