How to eliminate duplicate lines within a cell

[kgraham2]

I need help eliminating duplicate lines within a cell. I've concatenated cell that have duplicate entries. Is there a slick way to remove the duplicates within each cell?

Example, got to do this thousands of times within a spreadsheet.
Got cell
SDD_T4_4555
SDD_T4_108
SDD_T4_108
SDD_T4_4378

Want cell
SDD_T4_4555
SDD_T4_108
SDD_T4_4378

[FDibbins]

try using data - remove dupliactes?

[kgraham2]

Thanks for responding.
That works good for when you want to get rid of duplicat cells, unfortunately I need to elimiate lines that are duplicated within a cell. Any other ideas?

[FDibbins]

that was not what your example showed? or did you mean that this is all in 1 cell?

SDD_T4_4555
SDD_T4_108
SDD_T4_108
SDD_T4_4378

[jindon]

VBA solution
Select the cell(s) then run the code

Please Login or Register  to view this content.

[Winon]

Hello kgraham2,

Here is a very nice Code from Mudraker: http://www.excelforum.com/excel-gene...in-a-cell.html

By tweaking it a bit, I got it to clear duplications within Cell contents in Column A, as demonstrated in the attached WorkBook.

Maybe Mudraker would not mind showing us how to change it in such a way that it handles the total UsedRange of the Active Sheet.