Cleaning Roster Datafor Union Campaign Success
Module 2 · Spaces, Line Breaks, and Invisible Characters › 2.5 Whitespace checkpoint
Subsection 2.5 · Checkpoint

Whitespace checkpoint

~5 min

Checkpoint · Module 2

Time to prove you have the Whitespace Wrangler badge. Open the Module 2 workbook and find cell B17.

Your task

Cell B17 contains a phone number with a hidden line break and a non-breaking space. Write a single nested formula in cell K17 that returns a clean phone string.

Hint

You need TRIM, CLEAN, and SUBSTITUTE in the right order. Inside-out: trim first, clean the line break second, strip the non-breaking space last.

You pass when:

Your formula reads:

=SUBSTITUTE(CLEAN(TRIM(B17)), CHAR(160), "")

And the cell shows:

770-555-0143

Badge unlocked: Whitespace Wrangler

Submit the cleaned workbook in the LMS to advance to Module 3 · Field Splitter.

Action: Submit your checkpoint workbook in the LMS to unlock the next module.