Left formula that takes the first two words

[fireguy7]

Hello all, What I'm looking to do is take a string of text and export just the first 2 words into an adjacent cell.

What I have is a data set where a person first and last name is the first two words in a sentance and I want to export just the name to another cell.

Example = Justin Fry is good at his job and is great to work with

in Cell A1 i would like to just see Justin Fry

The problem is all the names have different letter counts so I can't do just a simple Left 8 for example.

I have about 2k lines of text like this and I really don't want to remove the first and last names one by one.

thoughts?

thanks in advance.

[Ace_XL]

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[fireguy7]

Close Ace_xl this formula gives me the first name but I need the last name as well.

What I did to fix this is used

=TRIM(LEFT(A1,FIND("#",SUBSTITUTE(A1," ","#",3)))

This worked perfectly so big thanks.

[fireguy7]

Just want to amend my above comment. The reason why I had to switch from 2 to 3 is because there was an extra space at the start. without the space Axe_xl formula worked perfect. FYI