The MID function returns the characters from the middle of a text string, given a starting position and length.
=MID("This is a text.", 3, 5)
would return "is is".
- text - Required. The text from which you want to extract characters.
- start_num - Required. The position of the first character you want to extract. The first character in Text is 1. (Note: this is different from SUBSTRING).
- num_chars - Required. This specifies how many characters to return from Text.