Duplicate Values in cell

[ssj011]

Good Day Everyone

Need Help!!!!

Have a large data set where there are duplicate values in cells. I want a formula or any-other way to remove the duplicate values in cell..

E.g.

Charge Revsied
WTO/WTO/WTO/WTO/ILH WTO/ILH
WTO/WTO/WTO/WTO/SEJ WTO/SEJ
SEJ/WTO/WTO/SEJ/SEJ SEJ/WTO
WHI/WHI/WHI WHI
WHI/WHI WHI
WHI WHI
WHE WHE
WFC WFC
VGM VGM
ULT ULT
ULI/PSI ULI/PSI
ULI/IMP/PSI ULI/IMP/PSI
ULI/IMP ULI/IMP
ULI/DDF/IMP/PSS/PSI ULI/DDF/IMP/PSS/PSI
ULI/DDF/IMP/PSI ULI/DDF/IMP/PSI
ULI/DDF/IMP ULI/DDF/IMP
0

 

[Belleke]

With a UDF.
See attached

 

[ssj011]

Thanks !!!

 

[John Jairo V]

Hi, @ssj011! (And Belleke)

I leave two more options. With TEXTJOIN function (Office 365 - 2019) and with PowerQuery (free add-in since Excel 2010). Blessings!