Skip to main content
Windward

MID Function

autotag-wiki-logo.pngOverview

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