Forum Discussion

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...

excel

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

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
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)