Extract Only Uppercase Words

Published: 25 August 2024
on channel: CrispExcel Training & Consulting

161

Here is the function
=BYROW(B2:B10,LAMBDA(s,
LET(r,TEXTSPLIT(s," "),
f,TEXTJOIN(" ",,
IF(EXACT(r,UPPER(r)),r,"")),
f)))

Watch video Extract Only Uppercase Words online without registration, duration hours minute second in high quality. This video was added by user CrispExcel Training & Consulting 25 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 161 once and liked it 7 people.

106