Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula box character needed
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula box character needed
See Biff's post for the Alt + Enter.
If you want to add the carriage return in a formula use CHAR(10) ="This is one line" & CHAR(10) & "This is second line" Format the cell to wrap text and autofit the row and column. Gord Dibben MS Excel MVP. On Mon, 28 May 2007 14:22:01 -0700, David wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Formula for Displaying the First Character of a word | Excel Discussion (Misc queries) | |||
Wildcard Character in an Array Formula | Excel Discussion (Misc queries) | |||
Adding a character to a defined name with a formula or macro | Excel Discussion (Misc queries) | |||
Cell 255 character limit and formula | Excel Worksheet Functions |