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,