I'm not sure I understand your situation. Can you post a small sample of your data?
Text is a value also. Not sure why remove duplicates is not working?
You can make a rule and then sort by it or something..
I have a column with 1000 keywords, for eg. cell 1, tasty fish, cell 2, tasty meat, cell 3, tasty chicken, cell 4, good fruit, cell 5, good vegetables, and so on, I want to remove all the duplicated like "tasty" and "good", only keep the unique words.
Remove duplicates only removes if there are duplicate cell values like twice "tasty meat" or twice "tasty chicken"
Paste this into a vba module
will try soon thanks