Trim Function

Syntax

  TRIM(Text)

Text (required) – This is the text you want to remove extra spaces from.

Example

  In this example we use the function on the text “These     extra   spaces        are annoying!     ” to remove the excess spaces and result in the text “These extra spaces are annoying!”.