How to take a text difference in a cell

[ranabananagirl]

Hello,

I am trying to get the text difference of data in two cells:



A,B,D,E,F,C,G,H, (next cell) A,D,F,G,H,

I would like the results to be: B,E,C

Basically, the letters that are in Column 1 but not in Column 2.

Thank you,
Rana

[FlameRetired]

I couldn't do this without a helper row.

Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter not just Enter.

Row\Col	A	B	C	D
1	A,B,D,E,F,C,G,H	A,D,F,G,H		In A2 :{=INDEX(MID($A$1,ROW(INDIRECT("1:"&LEN($A$1))),2),SMALL(IF(ISNA(MATCH(MID($A$1,ROW(INDIRECT("1:"&LEN($A$1))),1),MID($B$1,ROW(INDIRECT("1:"&LEN($B$1))),1),0)),ROW(INDIRECT("1:"&LEN($A$1))),""),COLUMNS($A:A)))}
2	B,	E,	C,	array-entered and filled across to C2.
3	B,E,C			In A3 :=LEFT(A2&B2&C2,LEN(A2&B2&C2)-1)