Skip to main content

MID Function


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



  • 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.
  • Was this article helpful?