TRIM

Learn how to trim leading and trailing spaces in text fields.

The TRIM function removes leading and trailing spaces from a text string, but retains spaces that are between words.

Syntax

trim(value:string)

Arguments

value - Required. A text string.

Example

trim('   Lumel Technologies    ')
//Returns “Lumel Technologies"

Trim function

Excel equivalent

Trim