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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can Excel compare 4-ABC-SS to 4 ABC-SS and see them as the same (https://www.excelbanter.com/excel-worksheet-functions/24914-can-excel-compare-4-abc-ss-4-abc-ss-see-them-same.html)

Phil

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

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.

Harlan Grove

"Phil" <Phil @discussions.microsoft.com wrote...
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.

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)

All times are GMT +1. The time now is 04:24 AM.