Skip to main content

TRIM

The TRIM function removes all spaces from text except for single spaces between words.

Syntax​

=TRIM(text)

Parameters​

  • text: The text from which you want to remove extra spaces

Examples​

=TRIM("   Hello   World   ") // Returns "Hello World"
=TRIM("First    Second") // Returns "First Second"
=TRIM(" Extra  Spaces ") // Returns "Extra Spaces"