Formula to separate text in cell

S

Steph

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.
 
Y

Yorkie118

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
 
S

Steph

Thanks!!!

Yorkie118 said:
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
Click to expand...
 
S

Steph

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.
 
Top