TRIM Function
Removes all space from text, except for single spaces between words.
Syntax
TRIM (text )
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
text |
Required |
String |
The text from which you want to remove spaces. |
Return value
String
Remarks
You can use the TRIM function on text that you have received from another application that may have irregular spacing.
Example
TRIM ("January 1, 2003 ")
Returns "January 1, 2003".