Hi
see your post in Excel.worksheet.functions
P.S.: please don't multipost :-)

--
Regards
Frank Kabel
Frankfurt, Germany


C3 wrote:
How to format a cell that depending on amount of text, row will
increase its size or shrink.
Cell contains a formula that depending on result will show 0 (zero)
or some text data (long).


A B
----------------------------------------------------
1 | 0

----------------------------------------------------

or

A B
----------------------------------------------------
1 | asjkldfhaksjdh faksjdh flkasjdhflaksjdh |
| lasdjflajksd lfkja sdlkfjalsdkjf laskdjf |
| askdjflaksjdflkajsdlfkjas |
----------------------------------------------------