Removes leading and trailing spaces from a given string.

Usage

Trim(text)

text (required) Text or a column of text.

Example

Trim(" John Doe ")

  • Returns โ€œJohn Doeโ€

\[Trim of First Name\] = Trim(\[First Name\])

  • Returns:

Related resources