I have a large spreadsheet that I copied and pasted values from another sheet. Although there are many "blank" cells they apparently are not. When I do a COUNTA of a row (or column) which "appear" to be all blank, I get a value greater than 0. I have tried a find and replace to clear but no success. Currently, I have to manually filter and delete the blanks to clear them out which will take a long time to accomplish.
Any suggestions on how clear them so I can get an accurate count?
Any suggestions on how clear them so I can get an accurate count?