CreatE A Unique Delimited String From a Delimited String – Excel Formula Method (by David Hager)

[David Hager]

See:

https://dhexcel1.wordpress.com/2017...d-string-excel-formula-method-by-david-hager/

Convert a delimited string like, for example
a,b,c,c,d,a,e,r,h,h,t,o,x,a,b,c (in A1)

to

a,b,c,d,e,r,h,t,o,x

 

[Lori]

Given a solution has already been provided, is this a challenge to find other solutions? If so, a possible formula for unique alphanumeric delimited values (with Ctrl+Shift+Enter):

=TEXTJOIN(",",,FILTERXML("<x><a>"&SUBSTITUTE(A1,",","</a><a>")&"</a></x>","//a[not(. = preceding::a/.)]"))

 

[David Hager]

Given a solution has already been provided, is this a challenge to find other solutions? If so, a possible formula for unique alphanumeric delimited values (with Ctrl+Shift+Enter):

=TEXTJOIN(",",,FILTERXML("<x><a>"&SUBSTITUTE(A1,",","</a><a>")&"</a></x>","//a[not(. = preceding::a/.)]"))

Looks great, Lori. Thanks! Now I have to figure out how this works