← Back to level 1
Level 1Next
TRIM
A easy cleanup formula for removing extra spaces from text.
Syntax
=TRIM(...)Step-by-step explanation
- 1Understand the job that TRIM solves before you type the formula.
- 2Build or select the cells and ranges that TRIM needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Expecting it to remove all special characters
Using it before checking whether spacing matters
Forgetting it only removes repeated spaces, not every formatting issue
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=TRIM(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =TRIM(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use TRIM when pasted data has inconsistent spacing or messy input.
Match against the syntax block above.
Real-life use cases
Imported dataName cleanupText normalization
Related formulas