Description
Extracts a given number of characters from a Text, starting at a given position.
Syntax
MID(Text to Extract, Starting Position, Number of Characters)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Text to Extract (required) | Text | Any Dimensions | Text to extract characters from. |
Starting Position (required) | Integer | No Dimension or Dimensions of Text to Extract | Starting position of Text to Extract to extract characters from. |
Number of Characters (required) | Integer | No Dimension or Dimensions of Text to Extract | Number of characters to extract from the Starting Position. |
Returns
Type | Dimensions |
|---|---|
Text | Dimensions of Text to Extract |
Extracted characters from Text to Extract.
BLANK if Starting Position is a negative integer or 0.
BLANK if Number of Characters is a negative integer.
Examples
Formula | Result | Description |
|---|---|---|
| “c” | Starting from the third character, one character is extracted. |
| “bcd” | Starting from the second character “b”, the next three characters are extracted. |
|
| The Starting Position, -1, is invalid. |
|
| The Number of Characters, -1, is invalid. |
See also
Excel: MID
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!