Exercises / Cleaning text · 2 of 13
Clean up messy names
TRIM removes spaces at the start and end and squeezes double spaces into one. PROPER capitalises the first letter of each word. Nest them to clean a name in one step.
Your taskThe names in column A were typed carelessly. In B2, use TRIM to remove the extra spaces and PROPER to capitalise each word. It will be copied down to B7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | Raw name | Clean name |
| 2 | maya chen | |
| 3 | LUCA romano | |
| 4 | amara OKAFOR | |
| 5 | jonas berg | |
| 6 | elira kola | |
| 7 | sam TAYLOR |