Line break within an Excel formula

[kaplin]

I'm trying to put a line break in an excel formula in a spreadsheet.

Ex. ="Hello"&Char(13)&"World"

The problem is that the return shows up as a box symbol (ie does not insert the line).

Is there anyway to type the formula such that excel recognizes the line break?

Thanks,

Christine.

 

[SkipVought]

Christine,
[tt]
="Hello"&CHAR(10)&"World"
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

Oh, I forgot to add...

Format the cell to WRAP.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[kaplin]

Thanks! The 13 was a typo - it was the "wrap" that I didn't realize!