Got first word of text string, can I get 2?

[crckrjck]

Found a function to get the first word of a string, can this be made to get 2
or 3 words?

=LEFT(A1,FIND(" ",A1))

 

[ruffnro]

Great question. The next part of the find formula (that you don't always
need to use) is the starting point. Therefore, to get the first two words,
use this formlula:

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

This puts the starting point after the first word.

Enjoy!

 

[Randall Parker]

Depending on the number of words, you might have a shot. If you have two or
three words only, try the following commands:

=LEFT(A1,FIND(" ",A1)) Finds first word
=MID(A1,FIND(" ",A1),FIND(" ",A2) Finds middle word (or 2nd of 3)

The downside is that you pick-up spaces, but I hope I moved you closer to
your goal.