TRIM Function
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 |