how will I get first two words from a Text

[niladri20052006]

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

 

[VoG]

Try

=LEFT(A1,FIND(" ",SUBSTITUTE(A1," ","~",1))-1)

 

[jmthompson]

=left(a1,(find(" ",a1,find(" ",a1)+1)-1))