Text with extraneous spaces removed
Returns the specified value with leading and trailing spaces removed and each interior multi-space reduced to only a singe space.
Sample usage
TRIM(" Hi there!")
: Hi there!
TRIM("Hi there! ")
: Hi there!
TRIM("Hi there!")
: Hi there!
Syntax
TRIM(value)
value
- Value of any type.