Parsing Text ( Last Name, First Name )

I have a list of names and titles as follows:

Gray Raymond E

I would like to parse the information with last name
( Gray ) in one field and the remaining name ( Raymond E )
in a separate field.

Last name and First name are varied in length throughout the list.

Is it possible to parse everything to the left or right of
the space?

I use the following formulas to parse street name and number,
however, it doesn't seem to work with text.

B1: =--(0&LEFT(A1&" ",SEARCH(" ",A1&"0 ")-1))

C1: =TRIM(SUBSTITUTE(A1,B1,""))


Thanks

this for the last name:

=LEFT(A2,FIND(" ",A2,1)-1)

this for the rest:

=RIGHT(A2,LEN(A2)-FIND(" ",A2,1))

should be fine as long as there are no spaces within the last name (hyphens are OK)