Description
Extracts a given number of characters from a Text, starting from the last character to the first.
Syntax
RIGHT(Text to Extract, Number of Characters)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Text to Extract (required) | Text | Any Dimensions | Text to extract characters from. |
Number of Characters (required) | Integer | No Dimension or Dimensions of Text to Extract | Number of characters to extract from the end of the text. |
Returns
Type | Dimensions |
|---|---|
Text | Dimensions of Text to Extract |
Extracted characters from Text to Extract.
BLANK if Number of Characters is a negative integer.
Examples
Formula | Result | Description |
|---|---|---|
| “abc” | All characters are extracted from “abc”. |
| “cd” | Only the last two characters are extracted from “abcd”. |
|
| The Number of Characters, -1, is invalid. |
See also
Excel: RIGHT
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!