I have text in cell A1 and a formula in cell B1 which returns "" (blank), causing the text from A1 to be "####" (because B1 is "non-empty" even though it's blank). I don't want to change the width of my columns. Is there any way to allow the text in A1 to overflow into B1? A way to return the formula in B1 so that excel recognizes it as truly empty?
No. You can't display content from one cell flowing into another cell if the second cell has a value or formula in it. You could use a macro to calculate the contents of B1, and clear it if the content is blank.
The better answer is make column A wider, which you don't want to do, or move the B1 content to another cell.
There is no method using formula that will return true blank.
And if the adjacent cell isn't true blank, text will not spill over it.
It simply cannot be done.
Alternative is to use other tools to display content of cell. Such as Comment, Modeless UserForm etc. But this requires vba code.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks