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)?
Please remember that we may receive commissions when you click our links and make purchases