View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson
 
Posts: n/a
Default How do I insert a new line of text inside a cell

Use alt-enter to force a new line (if you're typing).

In a formula:
=a1&char(10)&"hi there"&char(10)&b1



thudson wrote:

I want to have a
set of text
that has three lines
I can't figure out how to add an ASCII New Line Char

Tony


--

Dave Peterson