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 
.Pattern = "(.*-\d+)[^1-9A-Z].*"    'current pattern
.Pattern = "(.*-\d+)[A-Z].*"        'previous pattern provided
Previous thread:

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