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

[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.

 

[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.

 

[Gord Dibben]

Alt + Enter

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

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


Gord Dibben MS Excel MVP