Display Format in Cell

[Minitman]

Greetings,

I can get text to display multiple lines with correct break points by
using <Alt + Enter> to start a new line inside of the cell. This
shows correctly after that cell loses focus.

If I try to do that to a formula I do not get the line breaks, just
one long line which beaks at the end of the cell,

Any suggestions on how to get results of the formula to display
correctly?

TIA

-Steve Moulton

 

[Kieran]

Steve,


This works if the cell format is wrapped.

="A"&CHAR(10)&"B

 

[Ozzie]

To get the formula to display as text - add " to the front.

 

[Minitman]

It displays, it just doesn't wrap where I need it to wrap.

 

[Minitman]

Thanks Kieran,

That did the trick.

-Steve Moulton