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

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.

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

ALT-ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JKing" wrote in message ...
| 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.

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

Alt + Enter

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

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


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 13:12:04 -0700, JKing
wrote:

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.