I have a spreadsheet which contains info imported from another system. I
want to give users the chance to add records but they must follow the rules
so that the data remains consistent.

The problem I have is that there are 4 fields that I would like to have
completed from Picklists. The actual contents will vary depending on what is
downloaded from the other system and only certain combinations are allowed.
I have a list of all allowed combinations.

What I would like to do is concatenate the 4 fields so that the user only
has to pick once and then in different cells undo the concatenation so that
the four fields are presented in four cells. Unfortunately the contents of
the original four fields vary in length and even the number of words they
contain.

An example would be "Dog" "Four Legs" "Brown" "Fido". I want to be able to
combine all four, get "Dog Four Legs Brown Fido" put the result in a pick
list but when picked end up with a result that I can divide up to match the
original four fields.

Using Excel XP.

Any ideas?

John C