The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and last name into their own columns.
Separate first name
This formula uses the full name in field A2 and outputs the first full word before the first space.
Separate last name
This formula uses the full name in field A2 and outputs the last full word after the last space.