The TRIM function removes all leading and trailing spaces, and extra spaces between words in a text string.
TRIM
For example, if text imported from an external system includes irregular spaces, you can use the TRIM function to remove the spaces.
TRIM(Text)
Arguments
| Argument | Data type | Description |
| Text | Text | The text to trim extra spaces from. |
The TRIM function returns a text value.
Syntax example
TRIM(" Account Summary ")
Calculation engine functionality differences
You cannot currently use the TRIM function in Polaris.
In the Classic Engine, you can.
Excel equivalent
Examples
In this example, the Office locations line item contains the Las Vegas, London, and Melbourne values. The formula removes all irregular spaces from each value, and replaces extra spaces between words with single space characters.
| America | Europe | Australia | |
| Office locations | Las Vegas | London | Melbourne |
TRIM(Office locations) | Las Vegas | London | Melbourne |
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.