Hi
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?
THanks.
