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 real-world 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

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

    MID Function in Excel - Screenshot of Step 1

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

    MID Function in Excel - Screenshot of Step 2

  3. 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 ( , )

    MID Function in Excel - Screenshot of Step 3

  4. 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!

    MID Function in Excel - Screenshot of Step 4

  5. 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

    MID Function in Excel - Screenshot of Step 5

  6. Type close bracket sign

    MID Function in Excel - Screenshot of Step 6

  7. Press Enter
  8. The process is done!

    MID Function in Excel - Screenshot of Step 8



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

  1. Take the first name of the person!
  2. Take the middle name of the person!
  3. 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!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert