For the numbers,
if you know the number is suspose to be a 4 digit number, then you can flag
any 5 numbers.

"Al Franz" wrote in message
...
Is there any function or add-on that can allow me to compare two cells and
provide some type of similarity score? Would like to determine matches
such as "John Smith" to "Johnny Smith Jr.", or "5006" to 50006" at to flag
those rows some how.

Thanks for any ideas.