Description
Extracts a given number of characters from a Text, starting from the first character to the last.
Syntax
LEFT(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 beginning 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 |
|---|---|---|
LEFT(“abc”, 5) | “abc” | All characters are extracted from “abc”. |
LEFT(“abcd”, 2) | “ab” | Only the first two characters are extracted from “abcd”. |
LEFT(“a”, -1) | BLANK | The Number of Characters, -1, is invalid. |
See also
Excel: LEFT
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!
