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