fx =TRIM(A1)ABCJohnSmithJohn SmithJaneDoeJane DoeAlexWongAlex Wong
📝 Text

TRIM Formula for Text Manipulation

Remove extra spaces from text. Copy-paste ready for Excel, Google Sheets, and Airtable.

=TRIM(A1)
When you need this: When you import customer names from a database that has extra spaces (" John Smith "), use TRIM to clean them.

How it works

  1. 1TRIM removes leading spaces (before text), trailing spaces (after text), and extra spaces between words.
  2. 2Leaves one space between words.
  3. 3Perfect for data cleanup after imports.

Variations

Remove ALL spaces (including between words)
=SUBSTITUTE(A1," ","")
Trim and convert to proper case
=PROPER(TRIM(A1))

Related Formulas

CONCATENATE / TEXTJOIN — Join text from multiple cellsTextLEFT / RIGHT / MID — Extract part of a text stringTextLEN — Count the number of characters in textTextTEXT — Format a number as text with a specific formatText

Need a formula that's not here?

Generate custom formula →