TRIM function

Category: Text functions

What does this function do?

Removes all spaces from a string except single spaces between words.

Syntax:

TRIM(text)

• text (required): text from which you want spaces removed.

Examples:

=TRIM("    I love     Excel    ")= "I love Excel"