• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can I remove 100 characters that are duplicate and found in other cells?


New Member
I apologize if this has been asked before but I couldn't find it.

I want to be able to tell excel to remove at least 100 duplicate characters that are found in other cells. I uploaded my excel here so you can see what I mean:

So, these 100 characters...

.navheader { display: block; width: 120px; font-family: Georgia; font-size: 16px; font-weight: bold;

...are found in B2, B3, and B4. Is there a way to click on a button or execute a macro so that each time excel finds 100+ characters that are duplicate, to delete them, leaving only one copy of it?

Let me know in case I'm doing a bad job of explaining it.

Thank you so much,


Excel Ninja
As a new member, You should reread Forum Rules
You seems to have skipped some sentences about cross-posting.