Excel formula to remove duplicates in a cell

[sharshra]

I have an output from TEXTJOIN, which has duplicates. I need unique values as the final output. I searched internet & found there are VBA UDFs to remove duplicates in a cell. But I want to achieve the same using Excel formulae.

Are there any options to remove duplicates in a cell using Excel formulae? Or is it possible to have an output from TEXTJOIN with unique values only? Please advise.

Example for illustration only-
Output from TEXTJOIN - abc, def, abc, xyz, bcd, cde, def, mno
Desired output without duplicates - abc, def, xyz, bcd, cde, mno

 

[sharshra]

In post 1 you seemed to also be asking if your original TEXTJOIN function could get the unique values directly but you didn't address that part of my last post.

I used the basic TEXTJOIN function to get an output with duplicate values & hence asked if there are any options to get unique values with TEXTJOIN function. Now, I got the answer from your & Rick's posts. Hence, I think it will not add much value in sharing the original formula that I used.

 

[RoryA]

The point is that you could probably use UNIQUE within your original TEXTJOIN formula so that it doesn't return duplicates in the first place.