MID function comes under the TEXT category in Excel.
MID FUNCTION is used when we need to extract letters at some specific position in a given text string.
MID FUNCTION returns a specific number of characters from a text string,starting at the position you specify, based on the number of characters you specify.
PURPOSE OF MID FUNCTION IN EXCEL
MID FUNCTION returns the specified number of characters from a string, counted from the right.
PREREQUISITES TO LEARN MID FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
SYNTAX: MID FUNCTION
The Syntax for the function is
=RIGHT(STRING, STARTING NUMBER, NUMBER OF CHARACTERS)
STRING Text from which the characters are to be extracted
STARTING NUMBER Starting point(CHAR NUMBER) ,from where the extraction needs to be started
NUMBER OF CHARACTERS The number of characters to be extracted. (COUNTED FROM THE STARTING NUMBER).
EXAMPLE:MID FUNCTION IN EXCEL
Let us try to extract the 10 letters from starting from letter no. 3 from the text
“A little brown bear”.
STEPS TO USE EXACT FUNCTION
uses of MID FUNCTION
MID FUNCTION is very useful if we have a lot of data having the same and fixed format. As we discussed in LEFT AND RIGHT functions, let us take the date example.
Let us extract the month part from the above mentioned data.
The above example shows how we separated the month part of a date.
This can be achieved by setting the format type of the cell but if the scenario is very random, this method is quite helpful.
The MID function starts picking up the characters from character no. 4 and picks up 2 characters as shown in the function.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.