MID function in excel worksheet

Excel Version in which MID function can work:

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.

MID function
MID function

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
=MID(B4,3,4)
Examples:
If we want to extract 3 letters beginning from 4th letter from following Texts:
Assume Cell reference is B4,B5 and B6 respectively.

Words Formula Result
Following  =MID(B4,4,3) low
Reference  =MID(B5,4,3) ere
Pagelayout  =MID(B6,4,3) ela

Similarly you can also apply this formula with any other function like IF,AND,OR etc.

Leave a Comment