=LEFT(A1,Find(" ",A1)-1)
and
=RIGHT(A1,LEN(A1)-FIND(" ",A1)-1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Access Front End" wrote in
message ...
Hi Anyone!

How do you FIND a string in a cell. I know that in C language you can use
"string" but what do you use in Excel. I have a cell that contain First
name
then comma some time a space then Last Name. How can I get the Firstname
in
one column & Last name in one column by using the formula. Thanks

Ngan