Question: what is the formula in excel to separate first and last name?
Answer: 1. 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.