Skip to main content
Windward

SUBSTRING Function

autotag-wiki-logo.pngOverview

The SUBSTRING function returns the characters from the middle of a text string, given a starting position and an ending position.

For example,

=SUBSTRING("This is a test.", 5, 7)

would return "is".

Syntax

SUBSTRING(text,start_num,end_num)

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