hockeyadc,

I would say that decoding the part number is probably the best way to do it. Even if there are 10 different formats, each part number should be unique, so decoding shouldn't be much of a problem. The macro can check for the different format styles and then decode the part number accordingly.