Field-splitting checkpoint
Open the Module 3 workbook. Column D contains 80 full addresses jammed into one cell. Your job is to split them into Street, City, State, ZIP across columns E through H.
Use a formula, not Text to Columns. The roster is shared and the field rep will keep adding rows.
Your task
In cell E2, write a formula that spills across four cells (E2:H2) and produces:
1247 MLK Jr Dr SW | Atlanta | GA | 30310
Then drag the formula down so every row in D gets split. Flag any row where the spill produces fewer than 4 cells — those addresses are missing commas and need surgical extraction.
Hint
SPLIT is a single formula that produces multiple cells. Place it in E2 only — it fills the rest. For the State+ZIP edge case, you have a choice: nest a second SPLIT, or accept three cells and treat the State+ZIP combination as one field.
You pass when:
Your formula reads (one of these):
=SPLIT(D2, ",")
or, for full four-column output:
=SPLIT(SUBSTITUTE(D2, " ", ",", LEN(D2)-LEN(SUBSTITUTE(D2," ",""))), ",")
And the row shows:
1247 MLK Jr Dr SW | Atlanta | GA | 30310
Badge unlocked: Field Splitter
Submit the cleaned workbook in the LMS to advance to Module 4 · Placeholder Detective.
Action: Submit your checkpoint workbook in the LMS to unlock the next module.