trim

Use the trim function to remove any leading and trailing spaces from a Text value. The trim function returns a Text value.

Function format

trim(Text source)

  • source: the Text value which leading and trailing spaces are removed from.

trim example

trim("    Hello, world!    ")

The formula returns the Text value Hello, world!.