Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal Seeking to a Cell instead of a hard number nate Excel Discussion (Misc queries) 1 August 1st 07 04:34 PM
How do you do hard returns in 1 cell? entering address in 1 cell Jenn Excel Discussion (Misc queries) 2 June 18th 07 03:28 PM
HARD RETURN IN A CELL Dave T Excel Discussion (Misc queries) 4 April 18th 07 03:14 AM
How do I split a one cell which has a hard return? GatorGirl Excel Discussion (Misc queries) 2 June 19th 06 10:06 PM
How do I insert a "hard return" in a cell? cari Excel Discussion (Misc queries) 1 July 5th 05 06:22 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"