text validation

[jock wick]

can someone help me validate text where there is 3 text codes in a cell.
these need to be validated against a list of about 10 text codes.
Please help my head is hurting

 

[Harlan Grove]

can someone help me validate text where there is 3 text codes in a cell.
these need to be validated against a list of about 10 text codes.

Unclear. What do these cells look like? How about a simple, plain text
example?

 

[Debra Dalgleish]

You can do this with code. There's an example here:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'