Navigation:  Formulas and functions > Functions from A to Z > TRIM (remove spaces from text)

Syntax:

TRIM(text)

Description:

This removes all spaces at the beginning and end of the specified text string.

Example:

TRIM("    Text  ") returns text

See also:

CLEAN