How to identify similar (not duplicate) text within same column

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using remove duplicates or conditionally formatting doesn’t work. 

For example

DTS Digital Entertainment  Hamilton House 2  National Technology Park
DTS Licenising Ltd  Hamilton House 2  National Technology Park
DTS Licenising Ltd, Hamilton House 2National Technology Park
DTS Licenising LtdHamilton House 2National Technology Park
Hamilton House 2  National Technology Park

Hamilton House 2 National Technology Park

This address is all for the same customer, but it shows up as 6 different addresses because of slight spelling variations.

Does anyone know of any formatting or formulas I could use to find the “similar” addresses in this column? There are over 6000 lines of data so I can not do this task manually. 

 

Thanks

Sam 

 

By: Sam

Leave a Reply

Your email address will not be published. Required fields are marked *