MID Function

Overview

The MID function returns the characters from the middle of a text string, given a starting position and length.

For example,

=MID("This is a text.", 3, 5)

would return "is is".

Syntax

MID(text,start_num,num_chars)

• 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.