How do I change a blank ("") value to a cell with no value?
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!
|