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
Previous thread:Please Login or Register to view this content.
http://www.excelforum.com/excel-prog...2-columns.html
Bookmarks