Thread: Seeking the character code for entering a Hard Return in a cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote