TRIM
Description
TRIM removes all spaces from text except single spaces between words.
Syntax
TRIM ( text )
Parameter |
Description |
text |
Any text string or a reference to a cell that contains a text string. |
Remarks
Text that is imported from another environment may require this function.
Example
This function returns Level 3, Gate 45:
TRIM(" Level 3, Gate 45 ")
Also, see