deleting repeating text from a column where each cell in the column has multiple text phrases

Occasional Visitor



I have an excel file with a  column that has over 500 cells.  Each cell has multiple text phrases in it seperated by a comma or a semi-colon.  What I would like to do is delete all the recurring phrases in the column as a whole so that I am left with text in a new column that has only the unique text phrases in it as identified from the original 500 cells.


Can someone help in this regard?



0 Replies