Is there a way to make supposedly blank cells truly blank?
I have had a bunch of formulae evaluate to
"", whereafter I proceeded to copy the results and paste values. Now when I check for blanks using
IF(A1="",TRUE,FALSE) I get
FALSE, unless I select the pseudo-blank cell and press delete first.
There are quite a few of these cells so I tried using F5 (Go To Special) but none of the options (blank, constants, etc.) give the appropriate selection of the pseudo-blank cells.
How do I locate all these pseudo-blank cells in one go and delete them so that I can obtain truly blank cells?