| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a special character for "ALT+ENTER" for text formulae?
I can enter in the middle of a text cell "ALT+ENTER" to break to a new line
but I want to do this in a cell with a formula. It makes the text readable. So I want to know if there is a unicode or something that can be used to represent "ALT+ENTER" in the formula. This is in Excel 2003. Any help appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a special character for "ALT+ENTER" for text formulae?
The cell still has to be set to wrap text...
="This is a " & CHAR(10) & "test" HTH, Paul -- "Bill sailing" wrote in message ... I can enter in the middle of a text cell "ALT+ENTER" to break to a new line but I want to do this in a cell with a formula. It makes the text readable. So I want to know if there is a unicode or something that can be used to represent "ALT+ENTER" in the formula. This is in Excel 2003. Any help appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a special character for "ALT+ENTER" for text formulae
Thank you for quick response - problem solved.
Bill "PCLIVE" wrote: The cell still has to be set to wrap text... ="This is a " & CHAR(10) & "test" HTH, Paul -- "Bill sailing" wrote in message ... I can enter in the middle of a text cell "ALT+ENTER" to break to a new line but I want to do this in a cell with a formula. It makes the text readable. So I want to know if there is a unicode or something that can be used to represent "ALT+ENTER" in the formula. This is in Excel 2003. Any help appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
| Search for "Alt-Enter" character | Excel Discussion (Misc queries) | |||
| Versatile "adaptive" formulae? (instead of "hard"coded IF tests) | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| error: "invalid character in text conent" How do I open this file | Excel Discussion (Misc queries) | |||
![Bill sailing[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
