How do I use TRIM in Excel?
Use TRIM when you want to clean extra spaces from text. Enter Text in that order, then add optional arguments when needed.
Excel Function
TRIM
Removes extra spaces from text.
TRIM(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use TRIM to trim cell B2 (Name in column B) by removing leading and trailing spaces and collapsing repeated spaces.
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=TRIM(B2)Result
Taro Tanaka
Practice This Function
TRIM FAQ
Where can I practice TRIM?
Use the "Start Function Practice" button to jump straight into TRIM drills.
What arguments does TRIM use?
The main arguments are Text. Enter them in order.