MID Function in Excel
In this tutorial, you will learn about how to use excel MID function. MID function in excel is useful to get characters as you desired from a data in this spreadsheet software.
Why We Need to Learn About Excel MID Function?
Various kinds of filling or data in cell of spreadsheet software is comprised of a group of character which form it. Sometimes, we need to get some characters that are part of it for our next data analysis process in our job or business.
In another case, if we download a database that is in the company online system, then the data is often not clean and got mixed up in a column. We need to do separation process on it so we can analyze the data further.
As a realworld example of illustration in work or business, imagine that we want to analyze customer database that we get from our company system. Probably there is a column in the customer data table in our spreadsheet which is filled in with an index in which there is a code that can be translated into the data that we need for our analysis needs. We want to analyze it because the code can be processed further so that we can get a better understanding of the customer profile. But, of course, to separate the code from the customer index, it is pretty complicated if we do it manually. More so if we have more than hundreds or thousands of data row to be analyzed directly.
For that, we need a way so the character separation can be done automatically.
The solution is MID function in excel which can do it for us.
By using excel MID function, then we can get easily the characters that are needed from a data or cell filling, especially if they are in the middle of it. This, of course, makes it easier for us significantly if we have much data to take characters from, as long as we can identify the characters’ pattern on those data for accurate character collection process.
What is MID Function in Excel?
MID function in excel is a formula in this spreadsheet tool to take characters from a data or cell filling as we need, especially in the middle position. There are other formulas to separate characters besides excel MID function such as LEFT and RIGHT. The tutorials can be learned in other parts of this Compute Expert blog!
A little bit of explanation about the input in this formula:
=MID(text, start_num, num_chars)
Note:
 text = the data to be taken some of the characters from
 start_num = the starting position in the data to take the characters
 num_chars = the amount of characters that want to be taken from the data
How to Use Excel MID Function?
The following will explain in detail how to use MID function in excel. In utilizing this excel MID function, you need to specify the data or cell that you want to get characters from, the starting position they will be taken of, and how many characters you want to take from that starting position.
Using MID Function in Excel

Type equal sign ( = ) in the cell where you want to put the result in

Type MID (can be with large and small letters) and open bracket sign after =

Type data or cell coordinate where the data which you want to process with this formula is after open bracket sign followed by a comma sign ( , )

Type the number which represents the starting position where you want the characters to be taken from on the data that is inputted in the previous step/cell coordinate where the number is after comma sign then type comma sign ( , ) again. If you want to take them from the most front position from the data, then type 1 (the starting position behind it is 2 and so on). Don’t forget that space is also counted in this character position!

Type the number to represent how many characters will you take from the starting position or cell coordinate where the number is after comma sign

Type close bracket sign
 Press Enter

The process is done!
Exercise
After you have learned how to use excel MID function, you can practice your understanding through the exercise below!
Download the file from the link and answer the questions below. Please download the answer file if you have done the exercise and sure about the result!
Link to download the exercise file for MID function in excel:
Download here
Questions
 Take the first name of the person!
 Take the middle name of the person!
 Take the last name of the person!
Link to download answer file:
Download here
Additional Notes
 Often in its use, MID function in excel is combined with FIND function on the input of the number which represents starting position for character taking. It is because often we want to refer to the position of a character in the data or cell content for the input of excel MID function and FIND can help you with it. The tutorial of this formula can be learned in other part of this Compute Expert tutorial blog!
 There are other characters’ separation formulas in this spreadsheet software such as LEFT and RIGHT. If you want, you can learn them from other parts of this Compute Expert blog!