=LEFT(A1,FIND("?",SUBSTITUTE(A1," ","?",2)))

"JDay01" wrote in message
...
I have a range of text fields with descriptions containing a combination of
words and spaces. I want to return the leftmost two words of each
description, however, the position of where the 2nd space occurs varies by
cell.
I have found a way to return the first word by using the following
formula:
=LEFT(E4,FIND(" ",E4)-1)) However, I cannot figure out how to return the
TWO words. Can someone help?