Removing duplicate words in a text tring seperated by a commas within a single cell
Hi, I'm trying to remove duplicate values in a text string separated by a commas in a single cell. I want to run it down through all cells containing data in Column A. Any ideas ? thank you
Example :
Data in A2:
red,car,boat,blue,red,mail,sun,blue,street
Result desired in B2:
red,car,boat,blue,mail,sun,street
Select the cells you want the macro to work on and push the button.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thanks Skywriter , But I could not get it to work. Here's the error message I got and a pic of the debugging screen. I'm using Excel for Mac, in-case that has something to do with it._1_Screen Shot 2015-05-28 at 10.25.33 PM.png_1_Screen Shot 2015-05-28 at 10.25.44 PM.png
Hi syncguy,
maybe this (see attachment)
Use in cell like
=UniqInCell(A1,",",1)
1 for Non case-sensitive, 0 for case-sensitive
Please Login or Register to view this content.
Yeah you probably don't have a file that's needed or it's not in the right place.Thanks Skywriter , But I could not get it to work. Here's the error message I got and a pic of the debugging screen. I'm using Excel for Mac, in-case that has something to do with it.
You should just go with one of the other solutions that don't need a reference to make them work.
Thanks for letting me know.
You can't use Dictionary with Mac OS.
It's a well-known issue...
Qualify well known.It's a well-known issue.
Jindon and Nilem , both solutions worked excellently . I'll specify Excel for Mac in the future...my bad. You guys are all geniuses ! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks