The MID function returns a specific number of characters from a text string, starting at a specified position.
If start_num is greater than the length of text, MID returns "" (empty string).
If num_chars is greater than the number of characters remaining after start_num, or if it is omitted, MID returns the remaining characters.
For example,
MID("The discount is 10% in March", 24, 10)
returns "March".
See also: