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!.