Excel Sorting Columns

[Guest]

I am new to excel and trying to do a cost analysis between suppliers. I need
to sort 2 different columns so they will match up based on product #. 2 of
the suppliers lined everything up exactly and the third is all different.
I'm trying to make sure each row is the same item#. Thank you VERY much.

 

[Dave Peterson]

I think you'll have to bite the bullet and fix up those entries.

If that third supplier used a common format, maybe you could use some
formulas/macros to fix it.

But you'll have to post a few examples of the before and after product numbers.

(It's not an easy task to do. Good luck.)