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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Comparing two lists 0
Identifying common data between 2 cells 1
how can I compare two columns 1
Merging from an Excel file with graphics 1
Excel - Compare spreadsheets and indicate matched data 4
Compare two lists 2
comparing two sheet of data -- cost price increases 2

Top