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,
Trajko
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:
Dropbox - File Deleted - Simplify your life
www.dropbox.com
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