Excel 2007 Data validation cell allow comma seperated

Question

Q: How to allow comma separated words in a Data Validation cell  from the “in-cell dropdown” list of words that are not comma separated”  (also known as comma delimited)

My Data Validation drop-down list has words without commas: 

Cascaded

Computer

In Warranty

Login

Order

Out Of Warranty

Specifications

Status

In the cell with Data Validation, I want to select one word from the in-cell dropdown list, then I want to type any other word also found in the same list (comma separated) such as:

Cascaded, Computer,  Out Of Warranty  

Computer, In Warranty

Computer, Login

Computer, Order

Computer, Order, Status

Computer, Specifications

Ido not want to set the List up with commas  such as the following list because it will not let me delete unneeded word, and besides that the list becomes too long if I have single words plus all of the comma separated versions of single words such as the following example:

Cascaded

Cascaded, Computer,  Out Of Warranty  

Computer

Computer, In Warranty

Computer, Login

Computer, Specifications

In Warranty

Login

Order

Out of Warranty

Specifications

Status

Answer 1

Question only applies to one colum and its in-cell dropdown list (all of my other columns have a different in-cell dropdown list specific only to that column. I do not want to pull words from different lists.

Answer 2

The only way I can think of is to have three columns using the same Data Validation list. Themn combine with with concatentation like =D10&", "&E10&", ". With some effor the unrequied comma when you have less than three items can be avoided. best wishes

---

Bernard Liengme, Nova Scotia, Canada http://people.stfx.ca/bliengme/