DashboardNovice
Member
My list values are comma separated. But suppose I want one of my list items to include a comma such as:
Bangalore, India
I tried enclosing this in " " but the quotes will appear in the pull down menu. If I type this as is, Bangalore is recognized as one item then India is recognized as another item. But I want Bangalore, India to be one item list.
Also, suppose I want a blank as a choice, just in case the user doesn't want to select from the list of options. How would I get a blank as a choice?
I know how to do these by referencing a named range, but I would like all of my entries to be hard coded into the DV list.
Bangalore, India
I tried enclosing this in " " but the quotes will appear in the pull down menu. If I type this as is, Bangalore is recognized as one item then India is recognized as another item. But I want Bangalore, India to be one item list.
Also, suppose I want a blank as a choice, just in case the user doesn't want to select from the list of options. How would I get a blank as a choice?
I know how to do these by referencing a named range, but I would like all of my entries to be hard coded into the DV list.
Last edited: