How do I change a blank ("") value to a cell with no value?

L

Lauren

I am trying to perform Descriptive Statistics in Excel using columns that
contain blank values resulting from a boolean statement that returns "" if
false. Excel will not allow me to run Descriptive Statistics beacuse the
blanks are non-numeric values. Is there any way to give these cells no value?
Replacing the blanks with zero is an option I prefer to avoid.
Thanks!
 
J

johnhildreth

Try filtering for "", then selecting the returned subset and clearing
their contents.

HTH,
John
 
Top