% similarity between 2 cells of text

Is there a method or formula of working out how similar the data is in two cells?
i.e. Cell A1 has "Mr John Moore" and Cell B1 has "John Moore" What is the percentage of similarity between these 2 cells?

Thank you

Below is a UDF (stored in a Module in VBE)

Please Login or Register  to view this content.

called from a cell along the lines of:

Please Login or Register  to view this content.

compares B1 to A1 - in this case returning 67%
(case sensitivity is optional)

Modify as appropriate.

Yes, the Function would sit in a Module and then (in macro enabled file) you can call the function from a cell as outlined.

You might find the code doesn't do exactly what you want (it was configured for someone else a while back with specific requirements), however, hopefully it will help to some extent.

Are Macros enabled ?

Did you store the UDF in a standard Module in VBE ? (eg Module1)


#NAME? generally results because the function name used is not recognised as "valid".

For demo. see attached.

(if you get #NAME? errors with said attachment then VBA is not enabled)

Pavbo, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.