Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
An ops analyst's "first word of each phrase" extractor is returning the word plus a trailing space for every row — "ABC " instead of "ABC", "hello " instead of "hello". Their formula in column B:
=LEFT(A2, FIND(" ", A2))
The bug is the classic FIND-anchor off-by-one. FIND(" ", A2) returns the position of the space, not the position of the character before it. LEFT(A2, FIND(" ", A2)) therefore slices from the start through (and including) the space — one character too many.
The fix: subtract 1 from the FIND result so LEFT slices everything before the space:
=LEFT(A2, FIND(" ", A2) - 1)
The data at A2:A13 has 12 phrases, each "word word…" shape with a single space after the first word. Use the corrected formula.
Your task:
Graded cells: B2 (ABC corp → ABC), B7 (red apple → red), B12 (core team → core).