Forum Discussion
Two types of blank in Excel
I have encountered two types of blank in Excel. The first, when you do =(the blank cell) in another cell, gives 0; the second gives blank. The first, when you do =(the blank cell)+1 gives 1; the ...
To add to the others' answers:
• Can also differentiate between the type of blank cells with =CELL("type",BlankCell) → 3 possible outputs: "b" (for truly blank), "l" (for label - a text string, even if empty), and "v" (for all other values - don't think this one can be blank).
• How to create each:
┣ For truly blank cell: Press Delete.
┗ For empty string: Use formula ="" → then copy that cell and paste it as a value.
• Can also differentiate between the type of blank cells with =CELL("type",BlankCell) → 3 possible outputs: "b" (for truly blank), "l" (for label - a text string, even if empty), and "v" (for all other values - don't think this one can be blank).
• How to create each:
┣ For truly blank cell: Press Delete.
┗ For empty string: Use formula ="" → then copy that cell and paste it as a value.