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)))
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)))