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:


https://www.dropbox.com/s/e5i96f58o3...test.xlsx?dl=0


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,
Trajko