There are a few ways to separate first and last name in Excel. One way is to use the text function. To do this, type "=text(A1,"")" into a cell and copy it down. This will extract the first name from the cell. To extract the last name, type "=text(A1,"")" into a new cell and copy it down. This will extract the last name from the cell.
Another way to separate first and last name is to use the left function and the right function. To do this, type "=left(A1,find(" ",A1))" into a cell and copy it down. This will extract the first name from the cell. To extract the last name, type "=right(A1,find(" ",A1))" into a new cell and copy it down. This will extract the last name from the cell.