Thanks for your replies! Unfortunetly I'm told the format for the part
#s have now changed... They're similar to before only they will always
be prefixed with two digits and MAY be suffixed with one letter. So
19ACOV084A is valid part # as i 17FV276. blah not worth it. the
formula i have now (first two digits of the letters) is good enough for
95% of the cases. Thank you and I'm sorry I wasted your time!


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=273584