The SUBSTRING function returns the characters from the middle of a text string, given a starting position and an ending position.
=SUBSTRING("This is a test.", 5, 7)
would return "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 0. (Note: this is different from MID).
- end_num - Optional. This specifies the position of the last character you want to extract.