Stages
Just playMission 1/5
Clean the names up
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Cut spaces with TRIM
Do thisMission 3/5
Join names with &
Do thisMission 4/5
Fix the shouting with PROPER
Do thisMission 5/5
A lookup that trims first
★★★
Run cleared.
🚀 Push it
- 🟢Clean a list of messy names you make up yourself.
- 🟡Use LEN to count the characters before and after TRIM.
- 🔴Explain why a stray space breaks a lookup.
🌐 Make it for real
Open a blank Google Sheet and build the sample name list from an empty grid.
Twist: type one more messy name at the bottom and fill the rule down to it.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Names cleaned by retyping them one at a time
- TRIM alone, leaving the names still in capitals
- The typed column overwritten instead of a clean column beside it