Share this article:

What it does: The MID() Function returns a specific part of a larger text string, subject to the arguments you provide.

Plain English: The MID() function is a close cousin of the LEFT() and RIGHT() functions. Instead of focusing specifically on the LEFT or RIGHT of a piece of text, you’re pulling from the middle of text string.

Arguments: MID(text, start number, number of characters)

  • Text – The text you want to pull a string from
  • Start number – Where you want to start in the string
  • Number of Characters – How many characters do you want to pull from the text string (starting at the start number)?