MID Function

Returns a portion of text based on a given starting point and number of characters.
Sample Usage
MID("Hello World!", 2, 5)
Syntax
MID(
  • text
  • start_position
  • num_chars
)
  • text
    —
    The text that you want to return a portion from.
  • start_position
    —
    Starting from the left, the number of the character you want to return.
  • num_chars
    —
    Starting from the left and depending on the start_position, the total number of characters to extract.
Related Functions
LEFT
RIGHT
SUBSTITUTE
REPLACE
FIND
Was this article helpful?
YesNo