Remove Unprintable Non-Blank Cells Having Zero Length Contents

[aaronb]

I did not understand your goal

Macro to get rid of that character in the workbook so the affected cells return true for an ISBLANK check.

[Rick Rothstein]

Macro to get rid of that character in the workbook so the affected cells return true for an ISBLANK check.

If you want a macro, then check out the code I posted in this message in different forum...

http://www.excelfox.com/forum/f13/tr...-155/#post1092