Find approximate matches

Closed
Bernd - Sep 15, 2010 at 03:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 16, 2010 at 09:30 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 16, 2010 at 09:30 AM
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
0