How to Use the TRIM Function in Excel (Remove Extra Spaces)

How to Use the TRIM Function in Excel (Remove Extra Spaces)

Messy data with extra spaces can ruin your formulas. Excel’s TRIM function is your best friend for cleaning it up.

🧪 What Does TRIM Do?

It removes:

• Leading spaces (before text)
• Trailing spaces (after text)
• Extra spaces between words (leaves only one space)

🧩 Syntax:

=TRIM(text)

Example: =TRIM(A1)

🔍 Example:

Cell A1 contains " John Doe " →
=TRIM(A1) returns "John Doe"

⚡ Why TRIM is Important:

• Fixes import issues (copy-paste from websites or PDFs)
• Ensures lookup functions like VLOOKUP() work properly
• Improves data consistency

🧼 Keep your spreadsheets clean and reliable with just one formula!

For more Excel cleaning tips, follow ScriptDataInsights.