Remove Duplicates in a Cell

Seems so easy, but rather (I may be wrong) isn't so.

Would be easy by UDF, but not by built in formulas.

I do not think tim's solution is a solution for this issue. So have a look on short UDF and how it works in attached sample file:

Please Login or Register  to view this content.

it is used as any built-in function.

Glad to hear that, hope it will suit also brianmcgee.

As of understanding the function - It's relatively easy to read (almost plain English) one point to notice is that when one adds to a collection (named singles) any item at the item_name key - it will raise an error if there is already such an item in the collection. so after going through all elements in array in a collection there are only single occurences of each item.

While in your file
Alt+F11 Alt+I M
in open window copy the code
close the whole VBEditor window (or just activate main excel window) and save your workbook in one of macro-friendly formats (xls, xlsm, xlsb) - not xlsx!
now you can use this function in this file as any sytandard excel function.

While re-opening the file later, remember to allow macro excecution.