Character for second line in a cell

  • Thread starter Gary Fitzgerald
  • Start date
G

Gary Fitzgerald

What character or entity does one enter to generate a second line of text in
a cell?
 
P

Pete_UK

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

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing Second Line in Excel 2
Entering a Text Symbol ? 2
How do I get a line break to always work? 2
Suppress Printing with Character in Excel File 2
Find Function 5
count a character 1
text columns in one cell 13
replace ' in cells 4

Top