View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Formula box character needed

Use the key combination of ALT ENTER:

1<ALT ENTERSales

Will produce:

1
Sales

This should automatically happen. If it doesn't format the cell to wrap
text:

FormatCellsAlignment tabWrap text

Biff

"David" wrote in message
...
At the top of the worksheet there are two boxes. The box to the left is
the
cell reference box. Just to the right of it is a box where a formula
appears
or if text, where text appears.

Is there an Excel 2003 character I can insert between two words to force
the
second word to automatically "wrap" to the space below (not the next
cell):

1
Sells

Right now I have to type 1 with a long space before typing Sells:

1 Sells


--
David