Thread: Character for second line in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
  
Posts: 2,203
Default Character for second line in a cell
Press [Alt]+[Enter] when typing into a cell, or
in VB use either Chr$(10) or the built-in VB constant vbLf, as
Range("A1")="Hello " & vbLf & "world"


"Gary Fitzgerald" wrote:

What character or entity does one enter to generate a second line of text in
a cell?
--
Thank you,
Gary

Reply With QuoteReply With Quote