Duplicate data in single field with delimiter

[jimbomcmucka]

Hi, I am hoping you guys can help and save me a load of time manually fixing some data.

I have a data field where multiple entries are stored in one cell using | as a delimiter. Which I have managed to handle so far using various substitutes and textjoin/textsplit. The problem that I am facing is that I have noticed many cells contain the same data multiple times. For example Cell A1 contains "123456|123456|123456|654321". Is there a way that I can show only unique results for this data set? So for the example before, just return "123456|654321".

Unfortunately, the data contained is not always the same length and can have any number of codes in each cell.

Hopefully I have given you enough to go on for some guidance, let me know if any further details can help!

Thanks,
James

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	123456|123456|123456|654321	123456|654321
Lists

Cell Formulas
Range	Formula
B2	B2	=TEXTJOIN("|",,UNIQUE(TEXTSPLIT(A2,"|"),1))

 

[jimbomcmucka]

How about

Fluff.xlsm
	A	B
1
2	123456|123456|123456|654321	123456|654321
Lists

Cell Formulas
Range	Formula
B2	B2	=TEXTJOIN("|",,UNIQUE(TEXTSPLIT(A2,"|"),1))

Amazing! Thanks so much, Fluff. You have just saved me HOURS of work.

 

[Fluff]

You're welcome & thanks for the feedback.