=left?

[dajope]

hey all.

is it possible with excel to do a formula to say:

=everything to the left of the " "
and
=everything to the right of the " "

EG.. in a field i have Joe Blog
I want a formula to seporate them, but the names have different lengths.

thanks

[daddylonglegs]

You can use these formulas

=LEFT(A1,FIND(" ",A1))

and

=REPLACE(A1,1,FIND(" ",A1),"")

[dajope]

thanks .