You're an HR analyst importing a 12-row roster from a CRM export. Column A has the names — but the export was a mess: leading/trailing whitespace, internal double-spaces, and inconsistent casing (alex CHEN, DANA Ortiz, etc.).
The downstream payroll system requires names in proper case with no extra whitespace: Alex Chen, Dana Ortiz, etc.
Your task:
- In column B (Clean Name), write a formula that strips whitespace and applies title-case to each name.
- The formula must drag-fill from B2 → B13.
Graded cells: B3 (was " bree lin" → "Bree Lin"), B5 (was "DANA Ortiz" → "Dana Ortiz"), B8 (was " GRETA fox " → "Greta Fox").
Open this problem on a desktop to attempt it.