I have found EXACTLY what I am looking for, but alas it is only for Windows versions of Excel (of course). Here is what I need: I have a spreadsheet with names (split into two cells, first and last) and addresses. If the names and addresses are an approximate match, I need something to happen (highlight, delete duplicates, etc.... I can do that code myself most likely). The tricky part is addresses. I want 1234 E. Broadway Street to match 1234 East Broadway St. I cannot use left, right, or mid functions because the variable characters aren't always in the same position. The "Fuzzy Lookup For Excel Add-In" seems to be what I need, but I can't test it for sure. Is there a way to do a sort of fuzzy lookup already built into Excel? Or a macro I can copy-paste to use (I'm not familiar with them, but I know they exist and maybe it's time I learn how). Any help, suggestions, etc. are much appreciated.