Copy everything before the 2nd space

[daniels012]

I have 6 words in column A
I want to put the 2 left most words into column B.
What is a formula that will give me such data??
The words are varied in size.

Thank You,
Michael

 

[Peter_SSs]

daniels012

Try =LEFT(A1,FIND(" ",A1,FIND(" ",A1)+1)-1)

 

[daniels012]

You are a blessing. Thank You so much. I have been working on this for about an hour.

So, if I wanted the 3 left words would I...

Try =LEFT(A1,FIND(" ",A1,FIND(" ",A1),A1,Find(" ",A1)+2)+1)-1)

?? I don't know??

Thank You!!
Michael

 

[Peter_SSs]

You are a blessing. Thank You so much. I have been working on this for about an hour.

So, if I wanted the 3 left words would I...

Try =LEFT(A1,FIND(" ",A1,FIND(" ",A1),A1,Find(" ",A1)+2)+1)-1)

?? I don't know??

Thank You!!
Michael

No, the syntax in your formula is incorrect. However, rather than extending the ideas in my previous post, if the number of words to be extracted might change or is more than two, then I suggest this alternative approach.

I have put the number of words to be extracted in C2 for ease of testing (but you could build it into the formula if you want. The formula in B1 is:
=LEFT(A1,FIND("@",SUBSTITUTE(A1&" "," ","@",C2))-1)

Mr Excel.xls
	A	B	C	D
1	one two three four five six	one two three	No of words required from A1
2			3
3
Left 2 Words

 

[daniels012]

Thank You SOOOOOOOOOOOOO much!

Michael