Select the cells containing the full names
Go to the Data tab
Click Text to Columns
Choose Delimited and click Next
Select Space as the delimiter and click Next
Choose the destination cells if needed
Click Finish
If the name is in one cell as Last Name, First Name, use a formula to split it
To get the last name, use `=LEFT(A1,FIND(“,”,A1)-1)`
To get the first name, use `=TRIM(MID(A1,FIND(“,”,A1)+1,LEN(A1)))`
Copy the formulas down for all rows
If needed, copy and paste values to replace formulas with text