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.