Formula to separate text in cell
 

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.

Formula to separate text in cell
 

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


"Steph" wrote:

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.

Formula to separate text in cell
 

Thanks!!!

"Yorkie118" wrote:

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


"Steph" wrote:

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.

Formula to separate text in cell
 

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.

"Yorkie118" wrote:

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


"Steph" wrote:

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.