Formula to separate text in cell

[Guest]

I need to find a formula that will separate first & last name in a single
cell and put into 2 separate cells. Any help would be appreciated.

 

[Guest]

Hi Steph,
Suppose you have name John Brown in E2, and you want John in F2 and Brown in
G2. I assume theres a space between John and Brown.
Type in F2:-
=Left(E2,Find(" ",E2,1)-1)
Type in G2:-
=Right(E2,Find(" ",E2,1))

hope this helps, Yorkie

 

[FuzzyD]

Hi Steph,

I am quite stupid when it comes to using functions. So here's how I would have tackled your situation :

Choose the whole Column which has your names in it (I am, like Guest before me, assuming that there's a space between ur first and last names).

Click on Data (on my standard tool bar), Click on Text To columns, Click on Delimited, Select only the SPACE checkbox and Hit Finish.

Should get you a neat split of first and last names in 2 separate cells.

Just a warning, always keep the column immediately to the right of ur "FULL NAME" column empty. Otherwise, the split up last names would erase any data there.

Hope this helps.

Fuzz.

 

[Guest]

Thanks!!!

Hi Steph,
Suppose you have name John Brown in E2, and you want John in F2 and Brown in
G2. I assume theres a space between John and Brown.
Type in F2:-
=Left(E2,Find(" ",E2,1)-1)
Type in G2:-
=Right(E2,Find(" ",E2,1))

hope this helps, Yorkie

 

[FuzzyD]

I get these results if i try guest's method...

Name First Last
John Galt John Galt
Jason Patrick Jason atrick
Archie Dodo Archie ie Dodo
Joshua Dider Joshua a Dider
Meredith Brooks Meredith th Brooks
Yu Chi Yu Chi

What am i doing wrong?? The split is not even.

 

[Guest]

Still running into problems with this formula with longer names, or with a
name in the following format, for example: McCullough, Reginald - if I
follow your formula I get "McCullough," in one column and "gh, McCullough" in
the next. I can change the formula for the first one to eliminate the comma,
but don't know how to just get the first name in the next column. Keep in
mind, all of the names, both first & last, have a varying number of
characters.