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.

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.

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.