For a better experience, please enable JavaScript in your browser before proceeding.

I want 1234 E. Broadway Street to match 1234 East Broadway St.

I cannot use left, right, or mid functions because the variable characters arent always in the same position.

The Fuzzy Lookup For Excel Add-In seems to be what I need, but I cant 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 (Im not familiar with them, but I know they exist and maybe its time I learn how).

Do the same with St.

Street and other common abbreviations.

Then you should be able to use exact match or even Filter by Unique.

Currently I highlight all matches with the same first 4 letters of first and last name and same first 3 characters of address (usually just the street number).

I do all of the conditional formatting highlighting after replacing all direction and other common address abbreviations.

Its just tedious and not quite as time-saving-efficient as I would prefer.

We also boast an active community focused on purchasing decisions and technical aspects of the iPhone, iPod, iPad, and Mac platforms.

Fuzzy Lookup Add-In For Excel Mac