Excel MID Function: In The Middle Of Nowhere!
The Excel MID Function is another Text manipulation function that will grab any of the characters that are in the midst of a string of text. It is yet another one of the most used functions that is great to know, when you need to pull specific information from your text.
Excel MID Function:
Syntax of the Excel MID Function:
- MID(text, start_num, num_chars)
- text (Required) - The string of text that has the characters you want to grab.
- start_num (Required) - The position of the first character you want to grab in the string of text. The first character in string of text has a start number of 1.
- num_chars (Required) - Specifies how many characters you want the Excel MID Function to return from the string of text.
- If start_num is greater than the length of text, the Excel MID Function returns an empty text response. (aka - "" double quotation marks = empty text)
- If start_num is less than the length of the string of text, but start_num plus num_chars goes beyond the length of the string of text, the Excel MID Function returns the characters up to the end of string of text.
- If start_num is less than 1 or num_chars is negative, the Excel MID Function returns the #VALUE! error.
- =MID("I am Batman!", 6, 6) = "Batman"
- =MID("I am Batman!", 3, 2) = "am"
Download The Example Spreadsheet Here:
Why use the Excel MID Function?
It is easy enough to use a combination of the Excel LEFT Function and the Excel RIGHT Function to grab the same information. The question then becomes, Why Do That When the Excel MID Function can do it in one fell swoop?!? That!! That is why you use this function over the others. It's that simple!
Sometimes the information you need is on the left side of the string of text and sometimes it is on the right. Easy enough, but when the text you need is somewhere in the middle of the string of text, then this function makes it easier to extract it than using a combination of other functions.
Share, Comment, Ask a Question or Rip Me a New One!
If you liked this article, please feel free to share it on social media and comment below if you have any suggestions, questions or corrections. Thank you for reading!
Remember to sign up to the newsletter email list, so you can catch all of the new posts and learn about upcoming topics, products and/or services.