Most likely you have a love/hate attitude towards spreadsheets. This highly useful tip will make you fall back in love with Excel. Microsoft does a great job at providing a solid add-in that makes fuzzy lookups relatively easy to perform.
Are there more powerful approximate string matching tools out there? Of course. But if you’re using Excel, this tool should be used before applying more complicated methods.
Everyone loves visualizations but sometimes you have to roll up your sleeves and clean up the data.
See also: Get Out of the Spreadsheet Abyss
Download: Fuzzy Lookup Add-In for Excel