G Gary Fitzgerald Dec 8, 2009 #1 What character or entity does one enter to generate a second line of text in a cell?
P Pete_UK Dec 8, 2009 #2 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
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
J JLatham Dec 8, 2009 #3 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"
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"
