TRIM Function
From Planfix
This function removes all spaces from text except for single spaces between words. It is used to remove unnecessary spaces that may appear when copying data.
Format
- TRIM(text)
The text argument is required. It is the string of text that needs extra spaces removed.
Example
| Formula | Description | Result |
|---|---|---|
| TRIM(" Income for the first quarter ") | Removes extra spaces, leaving one between words | Income for the first quarter |