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

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.
 
P

PCLIVE

The cell still has to be set to wrap text...

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

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top