How to compare data in two columns that are not written in the same way

[Oukira27]

Hello,

I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines.

The problem is that the way they are written are not the same.

For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86

And in the other I have : Visual C++ 2008 Redistributable Package (x86)


Would anyone be able to help me ?

Thank you

 

[Oukira27]

Something like a function or a macro could help me ? If yes do you have an example ?

Thank you a lot !