= left / Right

[Welsh Mark3]

I'm looking for two formulas, the first would take all characters before the first space (=LEFT.....) The second to take data after the first space (=Right....)

I have a column of full names that I'm trying to separate into first and last

 

[Fluff]

How about

=LEFT(A2,FIND(" ",A2&" ")-1)
=MID(A2,FIND(" ",A2&" ")+1,100)

 

[Welsh Mark3]

How about

=LEFT(A2,FIND(" ",A2&" ")-1)
=MID(A2,FIND(" ",A2&" ")+1,100)

Great thanks again

 

[Fluff]

My pleasure.