Pro lesson · 5 exercises · first one free
Cleaning and joining text
TRIM, PROPER/UPPER/LOWER, SUBSTITUTE, & and TEXTJOIN for tidy data.
Functions you'll practice
- TRIM
- PROPER
- UPPER
- LOWER
- SUBSTITUTE
- TEXTJOIN
How the lesson works
5 short exercises in a live spreadsheet: you type each formula yourself. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
Imported data often has extra spaces. TRIM removes spaces at the ends and turns double spaces into single ones.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.