TRIM

The TRIM function removes leading and trailing spaces from a text string while retaining spaces between words. This function is commonly used to clean and standardize text values.

Syntax

TRIM(value)

Arguments

• value: The text string to trim.

Return value

Returns the text string without leading and trailing spaces.

Example

TRIM("   Forecast Report   ")

Returns Forecast Report.

Excel equivalent

TRIM