To Separate First and Last Name from the List

Solution:
To retrieve the first name use the LEFT and FIND functions as shown in the
following formula:

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

To retrieve the last name use the RIGHT, LEN, and FIND functions as shown in
the following formula:

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