Description
Removes all spaces at the beginning or the end of a Text and replaces multiple spaces between words with a single space. You can use the TRIM function to remove irregular spacing from texts.
Syntax
TRIM(Text)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Text (required) | Text | Any Dimensions | Text to remove spaces from. |
Returns
| Type | Dimensions |
|---|---|
| Text | Dimesnions of Text |
Examples
| Formula | Result | Description |
|---|---|---|
TRIM(“ text”) | “text” | Irregular spaces before the text are removed. |
TRIM(“text “) | “text” | Irregular spaces after the text are removed. |
TRIM(“this is a sentence”) | “this is a sentence” | Irregular spaces between words in the text are replaced with a single space. |
TRIM(“ this is a longer sentence “) | “this is a longer sentence” | Irregular spaces before, after and between words are removed or replaced. |
See also
Excel: TRIM
Related articles: TEXT
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
