REDUCE Function in Excel (Extract Uppercase Words ONLY )

Thank you!!! I see some South African surnames...... interesting.

Great explanation Alan! Thanks for explaining these iterator functions.

Thank you Alan, alternatively, we can use the below formula:
=LET(
a,TEXTSPLIT(A2,," "),
TEXTJOIN(" ",,FILTER(a,EXACT(a,UPPER(a)))))
or if we want one formula without drag it down:
=BYROW(A2:A15,
LAMBDA(x,LET(
a,TEXTSPLIT(x,," "),
TEXTJOIN(" ",,FILTER(a,EXACT(a,UPPER(a)))))))

Dear Alan,
Just to spill, without using the TRIM function:
=BYROW(A2:A15,LAMBDA(a,REDUCE("",TEXTSPLIT(a," "),LAMBDA(acc,v,IF(EXACT(v,UPPER(v)),acc&v,acc))))) 🤗

Thank u Alan for this great video. In the true value of the of function. Can we just use V instead of acc” “&V ?

Excellent Video!

Excellent Sir

these are not available for users of 365?

Brilliant!

What is interesting is that it basically a looping inside Excel. Until Dynamic Array, i presume it only could have been done only in VBA.

Hocam emeğinize sağlık Excelde uzman değilim Excel 2016 kullanıyorum 2016 versiyona göre formül ile yapabilimisiniz