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()