You can do this with a vlookup formula. You would have to have a list
of what the codes meant. For example, create a range name for all of
the first values such as data1, the second set could be named data2 and
the third data3. The formula would look something like this:

=vlookup(left(a1,4),data1,2,0)&", "&vlookup(mid(a1,6,1),data2,2,0)&",
"&vlookup(mid(a1,8,2),data3,2,0))

Hope this helps.


Shannon8066 wrote:
I have a part number that is 2002-A-BB-MS where
2002=Solenoid Valve
A=2-way NC
BB=Brass

I want to be able to type in 2002-A-BB-MS...and have it say:

Solenoid Valve, 2-way NC, Brass...

Is there a way for me to do this?


--
Shannon8066
------------------------------------------------------------------------
Shannon8066's Profile: http://www.excelforum.com/member.php...o&userid=37552
View this thread: http://www.excelforum.com/showthread...hreadid=571858