An HR analyst's "convert to citation format" formula transforms "Jane Adams" into "Adams, Jane" for a roster export. The original calls FIND(" ", A2) twice in a single cell:
=MID(A2, FIND(" ", A2) + 1, LEN(A2)) & ", " & LEFT(A2, FIND(" ", A2) - 1)
The space position is computed twice per row, and the formula reads as a wall of FIND/LEN noise. LET binds the position once:
=LET(s, FIND(" ", A2), MID(A2, s + 1, LEN(A2)) & ", " & LEFT(A2, s - 1))
The win is mostly readability — s is named, the formula reads top-to-bottom, and FIND happens once per cell instead of twice.
The data at A2:A13 has 12 full names (single space between first and last, no middle names).
Your task:
- In column B (Last, First), write a LET-based formula that returns the citation-format name.
- The formula must drag-fill from row 2 → row 13.
Graded cells: B2 (Jane Adams → Adams, Jane), B7 (Felix Gomez → Gomez, Felix), B11 (Kyle Long → Long, Kyle).
Open this problem on a desktop to attempt it.