Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
An HR analyst's "split full name into first/last" pair of formulas calls FIND(" ", A2) three times across the two cells:
B2 (First): =LEFT(A2, FIND(" ", A2)-1)
C2 (Last): =MID(A2, FIND(" ", A2)+1, LEN(A2)-FIND(" ", A2))
The space position is computed three times per row across the two formulas. LET binds it once per cell:
B2: =LET(s, FIND(" ", A2), LEFT(A2, s-1))
C2: =LET(s, FIND(" ", A2), MID(A2, s+1, LEN(A2)-s))
The win is mostly readability — s is named, the formula reads top-to-bottom, and FIND happens once per cell instead of two/three times.
The data at A2:A13 has 12 full names (single space between first and last, no middle names).
Your task:
Graded cells: B3 (Bree Lin → Bree), C6 (Eli Brooks → Brooks), B10 (Ivy Wood → Ivy).