Forum Discussion
Excel counta is counting blank cells as if they had data. A lengthy fix is given
My mega spreadsheet is full of invisible junk scattered across cells. It is 1300 rows deep by 500 columns wide. Each bit of junk appears in the totals when I counta the rows or columns. I discovered ...
PondyDave A simplified solution is to use Find & Select > Replace. Leave the "Find what:" box blank, then "Replace with:" a text string or symbol that doesn't currently exist in the selected range or worksheet. For example, use the Greek Small Letter Lambda symbol "λ", then click "Replace All":
Find and Replace: Step 1
Then repeat, but with "λ" in the "Find what:" box, and the "Replace with:" box blank:
Find and Replace: Step 2
All cells that previously contained an empty string will now be blank. Cheers!