Hi all,
I've got a bit of a 'simple problem, simple solution' black-out here, so posting the question here
I've got a cell that contains something along the lines of:
Pouch:Delicious:Fresh:Selection:Jelly:Cat Food:Dry:Happy Cat
Now I loop through a number of strings, some of which contain duplicates of words that are already in the cell, for example, one string might be:
Pouch:Tasty:Fresh:Selection:Jelly:Cat Food:Dry:Happy Cat:Bag
While another might be:
Bag:Happy Cat:Fresh:Organic:Selection:Wet:Cat Food:Dry
While looping through my strings in VBA, I'd want to end up with only the unique words in the cell, so ultimately:
Pouch:Delicious:Fresh:Selection:Jelly:Cat Food:Dry:Happy Cat:Tasty:Bag:Organic:Wet
Assume the strings are one string with the colons included. I could split and loop through the splitted results, but would prefer to replace / remove any duplicates and add what's left to the cell.
What would be the most time-efficient way to do this?
Thanks!
Jasper
Bookmarks