Link to home
Start Free TrialLog in
Avatar of Laszlo Benedek
Laszlo BenedekFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Make excel long text into overflow to formulas returning "".

In excel if you have long text in a cell that doesn't fit, it can overflow into the adjacent cell, as long as the adjacent cell is empty. I wonder if I could get the same behavior when I have a formula in the adjacent cell returning "". Unfortunately by default in this case, the text doesn't overflow.

I'm using Excel 2010
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Laszlo Benedek

ASKER

OK, Thanks for clarifying. I think I'll just use a macro to make sure cells where the formula would return "", will actually be blank.