I have a very large spreadsheet that was given to me by someone who created
it from a database. I need to do a CountA to help sort it. But the "empty"
cells, which look blank to me, are not. So the CountA counts every cell.

Would you know how I can get the cells that look empty to be seen as blank
so I can do a valid CountA?