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)?
Pingback: Top 5 Things to Know in Excel | Every Day I'm Pivoting