Problem:
Separating the full names in column A into first and last names in columns B and C.
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)) Screenshot // Separating First and Last Names
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.