Formula Library

TRIM

text

Removes extra spaces from text, leaving only single spaces between words.

Syntax

=TRIM(text)

Example

Excel
=TRIM(A2)

Removes all leading, trailing, and extra internal spaces from the text in A2.

Tips & Notes

  • →Removes leading and trailing spaces completely
  • →Reduces internal multiple spaces to one
  • →Often needed after importing data from other systems

See Also

SUBSTITUTELEN

Need a custom TRIM formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.