I have a feed of approximately 2000 keys. Each key has 4 positions. Each
numeric position within the key represents different criteria. Please take a
look at the template below.

Template:
Position 1 Position 2 Position 3 Position 4
Year Month 1-Jackson Corp 1-Back Flap
2-Brynn-Myer 2-Outer Lace
3-Jarod Nickles, LLC 3-Corner Brick

For example:
Key: 0211
1st position: year (2000)
2nd Position: month (February)
3rd Position: Company (Jackson Corp)
4th Position: Description (Back Flap)

I would like Excel to read the key and provide a description based off of
the criteria above. I would figure that the keys need to be isolated by
position. Then each position needs to be identified according to the
template above.

I would appreciate any feedback you can provide.
Thanks.
Beeatrice