I have a simple data validation dropdown that I'm trying to do, but I DO NOT WANT to use cells to populate my list.

Something similar to what's below, but this obviously isn't working.

enter image description here

What formula do I need to input to create a list of strings in a cell?


Unless you mean something else, no need to wrap in quotes, or use the "=" sign enter image description here


You can put them in as a comma separated list:

with space,without



So for anyone who might have run into this problem, I found the solution (or rather the cause).

I had previously tinkered with the locale parameters of my system and altered the list separator character to semicolon in Control Panel > Clock & Region > Region > Additional Settings. When I used that instead of comma, the dropdown worked. The question is now whether this will continue to work on a system with the standard separator.

Not the answer you're looking for? Browse other questions tagged or ask your own question.