| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| replace new line character | Excel Discussion (Misc queries) | |||
| How to put line feed in a cell using a character not Alt/Enter | Excel Discussion (Misc queries) | |||
| Searching for a new line character. | Excel Discussion (Misc queries) | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
Linear Mode
