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.