TRIM

TRIM strips leading, trailing, and repeated spaces, leaving single spaces between words. It is the first thing to try when VLOOKUP or MATCH returns #N/A on values that look identical.

Excel

=TRIM(A2)

Google Sheets

=TRIM(A2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A2 is the text to clean.
2Leading and trailing spaces are removed.
3Multiple spaces between words collapse to one.

Need a version for your data?

Try: “Remove the extra spaces from the text in A2”

TEXTJOIN LEFT / RIGHT / MID SUBSTITUTE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

TRIM

Try it with your data

How it works

Related