Find approximate matches

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

i have two spreadsheets. Both contain company names, but the spelling is not exactly the same, e.g. if a firms name is Peach Corp. in the other list it might be Corp Peach or Peach Inc. i guess you get my point.

Is there a way or addin or macro that helps me to find approximate matching words/names??

Thanks in advance!

Bernd


1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Bernd,

You could use Ctrl+F and use a * as a wildcard.
So in your example use *Peach* to find cells with the word Peach in it.

Best regards,
Trowa