Is there a special character for "ALT+ENTER" for text formulae?

  • Thread starter Thread starter Bill sailing
  • Start date Start date
B

Bill sailing

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.
 
The cell still has to be set to wrap text...

="This is a " & CHAR(10) & "test"

HTH,
Paul
 
Back
Top