How to Extract Strings With Only 2 Words
Here are the 2options using dynamic array Excel Functions.
Option 1:
=FILTER(Names,
LEN(Names)-LEN(SUBSTITUTE(Names," ",""))=1)
Option 2:
=FILTER(Names,
ISNUMBER(--TEXTAFTER(Names&" 1"," ",2,,1)))
Watch video How to Extract Strings With Only 2 Words online without registration, duration hours minute second in high quality. This video was added by user CrispExcel Training & Consulting 23 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 110 once and liked it 3 people.