TRIM

Removes all spaces from text except for single spaces between words.

Syntax

TRIM(text)

Arguments

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

Example

TRIM("  Hello  World  ") → Returns "Hello World"
TRIM(B2) → Returns the text in cell B2 with extra spaces removed.