Overview
Grammar | TRIM(text) | Returns the text with all leading and trailing spaces removed. |
Parameter 1 | text | Text from which you want to remove spaces |
Notes
The function supports only one text parameter.
Example
The TRIM function can remove all extra spaces at the beginning and end of the text.
For example, to remove leading and trailing spaces from the text " software advice ", you can add a calculation indicator with the formula TRIM(" software advice "), as shown in the following figure.
Drag this indicator into the analysis area, as shown in the following figure.
Another example:
| Formula | Result | Notes |
|---|---|---|
| TRIM(" Monthly Report") | Monthly Report | - |
