Find and Replace Empty Texts ("")

[Jubinell]

Hi,

I'm having this problem whereby a few cells in my work contain empty texts. An empty text is represented textually in VBA with a pair of double quotation marks with nothing inside (I think).
This means that the cells don't display anything visible, but are not blank/empty.

So what happens is that formulas such as ISBLANK(), COUNTA(), etc. are returning unexpected results.

How do I find and replace these empty texts with nothingness?

If possible, no VBA please!

Thank you in advance

 

[Sandeep Warrier]

..........
P.S. Didn't know that there's a free version of ASAP as well. This is cool.

The only downside (or is it??) for the free version of ASAP is forced update to a newer version twice a year....

If you don't update to a newer version within some days of the update warning appearance, ASAP stops working.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">