Hi,

I have columns with part numbers. These part numbers will have slightly varying names, depending on who the customer is. For instance, CAF076-101, CAF076-1019W, CAF076-101--, CAF076-101A1BA, CAF076-101SV etc. are all the same parts ordered from different customers.

Is it possible to write a pattern that compares all the characters before the hyphen and just the three characters after the hyphen?

Right now I'm using this
Please Login or Register  to view this content.
Previous thread:

http://www.excelforum.com/excel-prog...2-columns.html