I am using the List option in Data Validation. I am not referring to a named range. Instead I want to hardcode all possible values. There are only three choices: active, inactive and blank.
Here is what I am using for the for Source field: Active, Inactive,<space, space space>. I have 3 spaces after Inactive so it does not literally say <space>. This does not work.

I have also tried Active, Inactive, "" but then the double quotes will appear. I don't want that.

I have also tried Active, Inactive, " " but then the double quotes with the space in between will appear. I don't want that either.

So when I am hard coding a list of choices, how do I make a blank available as a choice in the drop down list when the user clicks the cell with data validation?