MID
Return the given amount of characters starting at the given index from a string.
Syntax
=MID(Text, Index, Count)
Arguments
Name | Type | Description |
---|---|---|
Text | String | Text to extract string from. |
Index | Number | Index to start extracting from. |
Count | Number | Number of characters to extract. |
Return
Type | Description |
---|---|
String | The text that that is extracted from the given text using the arguments. |
Examples
Formula | Result | Comment |
---|---|---|
| "pl" |