Select the cells containing the full names
Go to the Data tab
Click Text to Columns
Choose Delimited
Click Next
Select Space as the delimiter
Click Next
Choose the destination cells if needed
Click Finish
Use the formula `=LEFT(A1,FIND(” “,A1)-1)` to extract the first name
Use the formula `=RIGHT(A1,LEN(A1)-FIND(” “,A1))` to extract the surname
Use the formula `=TEXTBEFORE(A1,” “)` to get the first name in newer Excel versions
Use the formula `=TEXTAFTER(A1,” “)` to get the surname in newer Excel versions