Extract text

[manoj_th]

Hi,

Please help me with the formula in extracting first 2 words in one cell.
I searched the forum before posting this, could not found the results for my requirement.
Uploading sample file. Thanks in advance.

 

[Chief Ace]

manoj_th

See attachment.

 

[Hui]

B2: =LEFT(A2,FIND(CHAR(135),SUBSTITUTE(A2," ",CHAR(135),2)))
copy down

if any don't have 2 spaces
=IFERROR(LEFT(A2,FIND(CHAR(135),SUBSTITUTE(A2," ",CHAR(135),2))),A2)
copy down

to understand how that works please read: https://chandoo.org/wp/2012/05/17/formula-forensic-no-021/

 

[rahulshewale1]

Hii@

Try this will also works.

Cell c2
=+MID(A2,1,FIND(" ",A2,FIND(" ",A2)+1)-1)

 

[pecoflyer]

There's more than one way to skin a cat
=LEFT(TRIM(A1),(FIND(" ",TRIM(A1)&" ",FIND(" ",TRIM(A1)&" ")+1)-1))
This being said, this problem has been solved a zillion times. Searching the Net first would have saved you (and us) time