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 |
|---|---|---|
| “text” | Irregular spaces before the text are removed. |
| “text” | Irregular spaces after the text are removed. |
| “this is a sentence” | Irregular spaces between words in the text are replaced with a single space. |
| “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!