View Single Post
  #1   Report Post  
Lauren
 
Posts: n/a
Default 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!