TRIM Function in Excel: Remove Extra Spaces

📎 This article includes 2 downloadable practice files ↓

TextLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Power combo
5. Common errors and fixes
6. TRIM in practice
7. Where you will use it
8. Worked example
9. Mistakes people make
10. Related functions
11. Continue learning

TRIM removes leading and trailing spaces and reduces multiple spaces between words to one. Essential after copying data from websites and ERPs.

Syntax

=TRIM(text)

Argument	What it means
text	Text to clean.

Examples

Example 1

=TRIM(A2)

” Asha Verma ” → “Asha Verma”.

Power combo

=TRIM(SUBSTITUTE(A2, CHAR(160), " "))

Also removes non-breaking spaces from web data, which TRIM alone leaves behind.

Common errors and fixes

You see	Why, and the fix
Lookup still fails after TRIM	Non-breaking spaces (CHAR 160) or line breaks (CHAR 10) remain. Use the combo above and CLEAN.

TRIM in practice

Where you will use it

• Clean names before lookups
• Remove double spaces from imports
• Fix values that look equal but don't match

Worked example

Brackets show where the text starts and ends after trimming.

Text	Formula	Result
ravi kumar	="["&TRIM(A2)&"]"	[ravi kumar]
Sharma Traders	="["&TRIM(A3)&"]"	[Sharma Traders]
North	="["&TRIM(A4)&"]"	[North]

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Non-breaking spaces from the web	Use SUBSTITUTE(A2,CHAR(160)," ") first
Expecting it to remove line breaks	Use CLEAN

Related functions

CLEAN · SUBSTITUTE · LEN

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Text guides →

REGEXREPLACE Function in Excel: Find and Replace With PatternsREGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask…T Function in Excel: Keep Text, Blank Out NumbersT returns text unchanged and anything else as an empty string. Rarely needed alone,…NUMBERVALUE Function in Excel: Convert Text Numbers With Any SeparatorsNUMBERVALUE converts text to a number using separators you specify — essential for European-style…VALUE Function in Excel: Convert Text to a NumberVALUE turns text that looks like a number into a real number, so SUM…

📎 Practice files for this article

⬇ Download all 2 files (ZIP · 38 KB)

• 📗
  Text-cleaning scenarios workbookExtract and clean text (GSTIN, PAN, emails, names) with PASS/FAIL checks, plus the 3 mistakes that break text formulas.
  ⬇ XLSX · 8 KB
• 📗
  Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.