Return missing text

[tonyrensya]

Hello there, I have a problem on returning missing text from a decimated list. how can it be done with formula? Thank you for your time!

A1: abcdefg
A2: abdeg
A3 expected value: cf

 

[Peter_SSs]

Is this what you mean?

23 09 08.xlsm
	A
1	abcdefg
2	abdeg
3	cf
Missing

Cell Formulas
Range	Formula
A3	A3	=REDUCE("",MID(A1,SEQUENCE(LEN(A1)),1),LAMBDA(a,b,a&IF(ISERROR(FIND(b,A2)),b,"")))

 

[Georgiboy]

Another option maybe:

Book1
	A
1	abcdefg
2	abdeg
3	cf
Sheet1

Cell Formulas
Range	Formula
A3	A3	=TEXTJOIN(,,TEXTSPLIT(A1,MID(A2,SEQUENCE(,LEN(A2)),1)))

 

[Peter_SSs]

Another option maybe:

Good idea, but simpler to use CONCAT instead of TEXTJOIN with a null joiner.
(Can also save a comma by not needing to use columns in the SEQUENCE function. )

23 09 08.xlsm
	A
1	abcdefg
2	abdeg
3	cf
Missing

Cell Formulas
Range	Formula
A3	A3	=CONCAT(TEXTSPLIT(A1,MID(A2,SEQUENCE(LEN(A2)),1)))