Remove Duplicates From Single CellJun 2, 2007
I have a column that has duplicate information in it.
An exapmle of one of the cells is:
BL, BL, BN, BOL, BOL, CP, CP, DRE, EG, EG, LM, LM, R, RE, RE, SP, SP, W, W
I want a vba macro to go thru the column and delete the duplicates in each cell.
So this one will be:
BL, BN, BOL, CP, DRE, EG, LM, R, RE, SP, W