MID function will work in Excel 2016, Excel 2013, and Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000.
About MID function:
MID worksheet function extracts specified number of letters from a word.
This is a built in function in excel that is categorized as text function.
It can be used as a worksheet function and VBA function in macro code that is entered through the Microsoft Visual Basic Editor.
In this post we discuss about worksheet function. We will post about VBA function soon.
Syntax for MID:
=MID(text, start_position, number_of_characters)
Text: The word which you want to extract from Start_position: The position in the word that you begin extracting from. The first position in the every word is 1. Number_of_Characters: Number of characters that you wish to extract from that word.
Using MID function:
If you want to extract 3rd and 4th letters from any word, the formula will be:
Let’s take B4 is the cell reference
If we want to extract 3 letters beginning from 4th letter from following Texts:
Assume Cell reference is B4,B5 and B6 respectively.
Similarly you can also apply this formula with any other function like IF,AND,OR etc.