Removes all leading and trailing whitespaces from the specified text.
Syntax
 Copy Code
|
|---|
TRIM( Text text ) → Text |
Parameters
- text
- Required. The text to trim.
Remarks
The following characters are considered whitespaces by this function: HORIZONTAL TABULATION (U+0009), LINE FEED (U+000A), CARRIAGE RETURN (U+000D) or SPACE (U+0020).
Example
| Formula
Copy Code
|
|---|
=TRIM(" Total income: ") |
See Also
Function Reference
LEFT Function
RIGHT Function
MID Function
REPLACE Function
SUBSTITUTE Function