Forum Discussion

bishopgt's avatar
bishopgt
Copper Contributor
Dec 17, 2019

Duplicate words

So I do a lot of things with Excel where things will duplicate column to column and I go to remove duplicates through the shortcut in data tab, but it can’t find any duplicates from there. My question would be, for example, if there is a column for companies and a column for addresses where the company is in both and I don’t want it there how could I go about deleting all of these duplicates ? Sorry, probably not the best explanation. Thank ahead of time though!
excel

3 Replies

Sort By
  • PReagan's avatar
    PReagan
    Bronze Contributor
    Dec 17, 2019

    Hello bishopgt,

     

    Hopefully I am understanding correctly...

     

    Let's say for example you have the company name "Microsoft" in cell A1 and the address "Microsoft 1234 First Street" in Cell B1. In cell C1 you could place the formula =SUBSTITUTE(B1,A1&" ","") to replace "Microsoft " with "". This would leave you with "1234 First Street" in cell C1.

     

    Is this what you're looking for?

     

     

    • bishopgt's avatar
      bishopgt
      Copper Contributor
      Dec 17, 2019
      That absolutely helps . But my issue is what if I have like multiple companies. Could I put multiple companies into that formula to get rid of multiple companies from multiple cells across columns ? Thanks !
      • PReagan's avatar
        PReagan
        Bronze Contributor
        Dec 17, 2019

        bishopgt 

         

        I'm afraid your description isn't very clear to me. Could you share a sample file of what your goal is? (Remember, of course, to remove any sensitive information)

Resources