![]() |
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! |
Try filtering for "", then selecting the returned subset and clearing
their contents. HTH, John |
All times are GMT +1. The time now is 05:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com