Excel formular - How to delete duplicate text in 1 cell

[TH123]

Hi all,

I'd like to get your support to keep 1 "a" & 1 "b" in 1 cell of each column while balance should be deleted. (I'd like to get result by using excel formular).
Thank you in advance.

Column 1	Column 2
a, a, a, a	b, b, b

 

[Peter_SSs]

Something like this?

23 05 15.xlsm
	A	B	C	D
1
2	a, a, a, a	b, b, b	a	b
3	a, b, a	a, b, c	a, b	a, b, c
Sheet9

Cell Formulas
Range	Formula
C2:D3	C2	=TEXTJOIN(", ",,UNIQUE(TEXTSPLIT(A2,", "),1))

 

[TH123]

Something like this?

23 05 15.xlsm
	A	B	C	D
1
2	a, a, a, a	b, b, b	a	b
3	a, b, a	a, b, c	a, b	a, b, c
Sheet9

Cell Formulas
Range	Formula
C2:D3	C2	=TEXTJOIN(", ",,UNIQUE(TEXTSPLIT(A2,", "),1))

Hi Peter,

I've tried this & result is great. This is exactly what I want to get. Thanks for your support.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.