Level 2TextPractice, 3 min
Clean a name with TRIM and PROPER
The task
Form fills arrive messy. In B2, clean the name in A2: strip the extra spaces with
TRIM, then fix the capitals with PROPER.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Raw name | Clean name |
| 2 | mARCUS del RIO | |
| 3 | jennifer WU |