Did you try Bernard's formula?

The CHAR(10) adds an internal line-feed.

Have you got the row set to "Autofit" along with "Wrap Text".


Gord Dibben MS Excel MVP

On Wed, 6 Feb 2008 06:07:02 -0800, akinovice
wrote:

Thank you very much for your reply. I am sorry Bernard but i do not
understand what you are saying? my text wrapping is working fine but when
using imported text from a formula it sops working. how will your formula
below change this?

"Bernard Liengme" wrote:

Experiment with =IF(A10,"abc"&CHAR(10)&"xyz","")
You will need to format the cell to allow text wrap (Format | Cells |
Alignment | check Wrap Text box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"akinovice" wrote in message
...
Hi i am using an IF statement to chose to display text from different
cells
and the problem is the text is displayed fine but i can not wrap the text
using the wrap funtion and so i have to change the cell size manually.
however since the length text which gets displayed can change this option
is
not useful. i want it to automatically change the size of the cell
regardless
of length of text (20 words max). Also when i manually type in the text
and
do not use a function the text wraps fine. Any ideas would be much
appreciated!