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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel Need Countifs Formula Help 0
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
VBA Multiple Line handling with Split() 1
PowerPoint Powerpoint Slow Animations 2
VBA set thick borders around non empty cells in range 0
Excel Convert word into numbers and back 4
Split column contents (de-concantenate) 7

Back
Top