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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
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!
 
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.
 
Back
Top