Text
Modern
MID
Returns characters from the middle of a text string, given a start position and length.
Available in All versions
Syntax
MID(text, start_num, num_chars)What it returns
The extracted substring.
Arguments
| Argument | Required | Description |
|---|---|---|
text |
Yes | The text string. |
start_num |
Yes | The position of the first character to return (1 = first). |
num_chars |
Yes | How many characters to return. |
Example
I1
N2
V3
O4
I5
C6
E7
Result
OI
MID returns N characters (here 2) starting at a given position (here 4).
=MID(A2, 4, 2)Important to know
start_num counts from 1, not 0.
All three arguments are required.