Excel BI Challenge Workout 004

Workouts Excel BI Challenge
21

LinkedIn Post by:
Jardiel Euflázio

=IFERROR(TEXTJOIN(" ",,FILTER(TEXTSPLIT(A2,," "),EXACT(TEXTSPLIT(A2,," "),UPPER(TEXTSPLIT(A2,," "))))),"")

A known variation

22

linkedIn Post
Juliano Santos Lima

A pinch of mistery.

=IFERROR(
 TEXTJOIN(" ",,
 FILTERXML("<t><s>"&
 SUBSTITUTE(A2," ","</s><s>")&" </s></t>",
 "//s[translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '')='']")),"")
23

LinkedIn Post by:
محمد حلمي

=MAP(A2:A10,LAMBDA(a,LET(
r,TEXTSPLIT(a," "),
TEXTJOIN(" ",,IF(EXACT(r,UPPER(r)),r,"")))))