Text Functions
Beginner
TRIM Function
Remove extra spaces from text using TRIM.
Task:
Clean up the text in column A by removing extra leading, trailing, and multiple spaces between words. Display the cleaned text in column B.
Learning Objectives:
- Learn TRIM function
- Understand space removal
- Practice data cleaning
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Original Text | Cleaned Text |
| 2 | John Smith | |
| 3 | Mary Jones | |
| 4 | Tom Wilson | |
| 5 | Sarah Brown |
What this exercise teaches (contains the answer)
The TRIM function removes extra spaces from text, leaving only single spaces between words. It's crucial for data cleaning operations.