Excel – How to create a data validation list WITHOUT using cells

data validationmicrosoft excelmicrosoft-excel-2010worksheet-function

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?

Best Answer

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

Related Question