Question: how to change full name to first and last in excel?
Answer: Enter the formula of =LEFT(A2,FIND(” “,A2,1)-1) in a blank cell, says Cell B2 in this case.
Enter the formula of =RIGHT(A2,LEN(A2)-FIND(” “,A2,1)) in another blank cell, Cell C2 in this case.