Check if substring exists in string and allow a difference of 1 character

[mk01111000]

Hello all,

I compare 2 cells to find out of their contents are equal:

Please Login or Register  to view this content.

However my list contains a lot of entries that are more or less the same except for 1 or 2 characters.
Is there a way to include these small variations.

Take the following as an example:

Corrosive solid, n.o.s.
Corrosive solids, n.o.s.

or

Hydrofluoric acid and sulphuric acid mixture
Hydrofluoric acid and sulfuric acid mixture

[WideBoyDixon]

A couple of functions for you, Similarity and Fuzziness:

Please Login or Register  to view this content.

Similarity will return the number of characters different between two strings. Fuzziness will return a percentage score based on the similarity. You could therefore try something like:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Would that work for you?

WBD

[mk01111000]

This might work. I'll give it a try.
Thanks WBD!