Good Afternoon All,

Does anyone have any ideas how to format a formula in
Cell "B1" so that if the result of the formulae is " "
that it will allow any narrative placed in Cell A1 to
spread across the face of cell B1, instead of cutting off
the narrative? I hope this makes sense.

Thanks in advance.

Ciara