Using autofit on cells which include ASCII 10 (LF) character

[DartGuru]

I use MS Excel 2003 SP2.

I have cells which include the line feed character ASC 10.
So a cell might contain four lines of text (with three LFs).

When I use autofit, either coded or double-clicking on the horizontal
row separator, the row reduces to the width of a single row of text,
such that the remaining three rows are not visible.

Is there a way around this ?

 

[Joel]

Auto fit the rows