ashillz
New Member
Hi All:
I have exported to .csv some data from a database that I am trying to gain some basic insights into (% of fields populated, for example). It appears that every cell with no value is formatted in a strange way that it does not register as a blank cell when using formulas like COUNTA(). I was curious if anyone had a suggestion on how to systematically correct these 'blank' cells. My current approach of filtering each column for blanks, selecting those blank cells and hitting 'Clear' is not feasible on a file with many columns.
Please see the attached sample file that demonstrates the problem here. Thanks for the help!
ashillz
I have exported to .csv some data from a database that I am trying to gain some basic insights into (% of fields populated, for example). It appears that every cell with no value is formatted in a strange way that it does not register as a blank cell when using formulas like COUNTA(). I was curious if anyone had a suggestion on how to systematically correct these 'blank' cells. My current approach of filtering each column for blanks, selecting those blank cells and hitting 'Clear' is not feasible on a file with many columns.
Please see the attached sample file that demonstrates the problem here. Thanks for the help!
ashillz