ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change a blank ("") value to a cell with no value? (https://www.excelbanter.com/excel-worksheet-functions/43735-how-do-i-change-blank-%22%22-value-cell-no-value.html)

Lauren

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!

[email protected]

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