Can Excel compare 4-ABC-SS to 4 ABC-SS and see them as the same

P

Phil

I have two data sources. One has the old part number and the other has the
new part number. I need to compare the two lists and build a third with the
correct part numbers to upload into our system.
 
H

Harlan Grove

Phil said:
I have two data sources. One has the old part number and the other has the
new part number. I need to compare the two lists and build a third with the
correct part numbers to upload into our system.
Click to expand...

If the only difference is that one has its first hyphen where the other has
its first space, try

"4-ABC-SS"=SUBSTITUTE("4 ABC-SS"," ","-",1)
 
Top