Newline within a formula

[Daner]

When you're entering regular data in a cell, you can just hit ALT+Ente
to insert a newline in that cell, but how can you do the equivalent o
that if your cell contains a formula? I tried doing:

=FORMULA1() & CHAR(10) & FORMULA(2)

since CHAR(10) is the newline character, but this didn't work. How ca
this be done?

Thanks for your hel

 

[Aladin Akyurek]

Format|Cells|Alignment|Wrap Text must be applied to the formula cell.