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