Splitting Full Names into First and Last with LEFT, RIGHT, and FIND

Question

In Column A, you have Full Names formatted as 'First Last' (e.g. 'Jane Doe', 'Alexander Hamilton'). Write formulas in Column B to extract the First Name and in Column C to extract the Last Name, adapting dynamically to varying character lengths.

Accepted Answer

Optimal Solution:
// First Name (Col B):
=LEFT(A2, FIND(" ", A2) - 1)

// Last Name (Col C):
=RIGHT(A2, LEN(A2) - FIND(" ", A2))

Technical Explanation:
FIND(" ", A2) locates the position of the space. LEFT extracts characters up to that position minus 1. LEN(A2) - FIND(" ", A2) calculates the remaining characters for RIGHT to extract the last name.

	A	E
1	Full Name (Col A)
2	Jane Doe	Target [Enter Formula]
3	Alexander Hamilton
4
5
6
7