sorovince
New member
- Joined
- Nov 21, 2020
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2019
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/e5i96f58o3pdq3i/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
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/e5i96f58o3pdq3i/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