Seeking the character code for entering a Hard Return in a cell?

J

JKing

Does anyone know how to enter a Hard Return within a cell? In my version of
Excel-- Professional 2003, in the Symbol dialogue box, a hard return is not
an option within the Special Characters box.
 
N

Niek Otten

ALT-ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Does anyone know how to enter a Hard Return within a cell? In my version of
| Excel-- Professional 2003, in the Symbol dialogue box, a hard return is not
| an option within the Special Characters box.
 
G

Gord Dibben

Alt + Enter

If in a formula use the CHAR(10) function.

="string " & CHAR(10) & "string2"


Gord Dibben MS Excel MVP
 
Top