Examples
TRIM(" Hi there!")
: Hi there!
TRIM("Hi there! ")
: Hi there!
TRIM("Hi there!")
: Hi there!
Syntax
TRIM( some-value )
Arguments
- some-value (of any type)
Return Value
Text: The content of some-value with leading and trailing spaces removed and each interior multi-space run reduced to only a singe space.
See Also
INITIALS(), LEFT(), LOWER(), MID(), RIGHT(), SUBSTITUTE(), UPPER()