Character for second line in a cell
 

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

Character for second line in a cell
 

Hold down the Alt key and press Enter at the same time to get a
linefeed within a cell, then carry on typing.

Hope this helps.

Pete

On Dec 8, 12:40*pm, Gary Fitzgerald
wrote:
What character or entity does one enter to generate a second line of text in
a cell?
--
Thank you,
Gary

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