Separate first and last name in Excel


Assuming that we have column A containing first and last name with a potential middle name, we can assume that taking first name can be conducted by getting the value from beginning until first space.

Getting the first name:

=LEFT(A2,FIND(" ",A2,1)-1)

Slightly more complex formula goes for the last name: