how will I get first two words from a Text

[niladri20005]

Hi All,

I have a list of company names. the company names looks like below:

Harland Financial Solutions
Lee Kum Kee (USA) Inc
El Monte City School District
The Heffernan Insurance Brokers

I want to get only first two words like below

Harland Financial
Lee Kum
El Monte
The Heffernan

thanks,

Niladri

[Cookstein2]

post deleted

[Colin Legg]

Either of these should do it:

=LEFT(A1,SEARCH(" ",A1&"  ",SEARCH(" ",A1&" ")+1)-1)

=LEFT(A1,SEARCH("||",SUBSTITUTE(A1&"  "," ","||",2))-1)