This function removes extra spaces from a string and leaves single spaces between words.

Syntax

TRIM(text)

Arguments

The argument specifies the string containing the spaces you want to remove.

Data Types

Accepts string data. Returns string data.

Examples

TRIM("" First    Quarter"") gives the result First Quarter

Version Available

This function is available in product version 1.0 or later.

See Also

CLEAN | SUBSTITUTE | Text Functions