Course
TRIM and text cleaning practice exercises
Five exercises, from removing extra spaces to building email addresses from messy names. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Remove extra spaces from customer names
The names in column A came from an export with extra spaces. In B2, use TRIM to clean the name in A2 so it reads Northwind Foods, with one space between the words and none around them.
| Imported name | Clean name |
| Northwind Foods | |
| Bluebird Studio | |
| Harbor Logistics | |
| Maple Dental |