MID(text, start_num, num_chars)

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:

Other text functions