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. 





By: Sam

26 thoughts on “How to identify similar (not duplicate) text within same column

  1. anabole steroide bestellen

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get four e-mails with the same comment. Is there any way you can remove people from that service? Many thanks!

  2. Acquistare Reductil in linea

    Unquestionably believe that which you said. Your favorite justification seemed to be on the net the simplest thing to be aware of. I say to you, I definitely get irked while people consider worries that they just do not know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

  3. sibutramin kaufen

    Thanks a bunch for sharing this with all folks you actually recognise what you’re talking approximately! Bookmarked. Kindly also talk over with my site =). We could have a link alternate contract among us!

  4. acheter steroides France

    A person essentially help to make seriously articles I would state. This is the very first time I frequented your website page and thus far? I amazed with the research you made to make this particular publish extraordinary. Wonderful job!

  5. Kaufen

    I just couldn’t depart your website prior to suggesting that I extremely enjoyed the standard info a person provide for your visitors? Is going to be back often in order to check up on new posts

  6. ig

    It’s really a great and useful piece of information. I am satisfied that you shared this useful information with
    us. Please stay us informed like this. Thanks for sharing.

  7. Elissa

    Awesome site you have here but I was wanting to know if you knew of any discussion boards that cover the same topics discussed here?

    I’d really like to be a part of group where I can get opinions from other knowledgeable people that share the same interest.
    If you have any recommendations, please let me know.
    Thank you!

  8. Buy Salbutamol

    I just could not depart your site prior to suggesting that I really enjoyed the standard info a person provide for your visitors? Is gonna be back often to check up on new posts

  9. review

    I?¦ve recently started a web site, the info you provide on this website has helped me greatly. Thank you for all of your time & work.

  10. BuyHerbs

    What i do not realize is in fact how you are not actually much more well-liked than you might be now. You’re very intelligent. You recognize therefore significantly when it comes to this subject, made me individually consider it from so many varied angles. Its like women and men are not involved except it is something to accomplish with Girl gaga! Your individual stuffs great. At all times take care of it up!

  11. HectorMow

    [url=]rauchen testosteron[/url]

    Thanks for the purpose of furnishing these types of substantial content.

  12. HectorMow

    [url=]how to boost testosterone[/url]

    You’ve gotten terrific stuff right here.

  13. Ouida Mccastle

    Im now not sure the place you’re getting your information, but good topic. I must spend a while studying much more or working out more. Thanks for fantastic info I was on the lookout for this information for my mission.

  14. vurtilopmer

    Aw, this was a really nice post. In concept I wish to put in writing like this moreover – taking time and precise effort to make an excellent article… however what can I say… I procrastinate alot and under no circumstances appear to get something done.

Comments are closed.