How to Use Excel MID Function?

Ads

Listen to this article

MID Function in Excel: Usually, the word “mid” represents the middle of something or the middle part of the range. Sometimes, you want to get a middle value from your Excel sheet, at that time we suggest you use the MID function. Excel has more number of built-in features, and it is one among them.

In Excel, the MID Function extracts the number (starting from the left side) or characters from the given string. You can customize the position and the number of characters that you want to extract from the given string. Today, we will see how to use the MID function in Excel using its syntax and examples. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Explanation of MID Function

It is one of the built-in functions in Excel.
MID Function extracts the number (starting from the left side) or characters from the given input string.
This function takes an empty space as a character, so it counts that while extracting the values from the input.

Syntax

Here, you will see the syntax of the MID function.
To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
Once you enter the formula, just click on the Enter button to get the result.

=MID(text,start_num,num_chars)

Argument Explanation

Text – The input text string or digits.
start_num – It is the position of the first character you want to extract from the given string. For example, the start_num for the first character in the text is 1.
num_chars – Number of characters you want from the specified position of the Text.

Examples

Let’s take a look at the following examples of MID Function in Excel for your reference.

Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
In the following screenshot, you can see that the input text string is placed inside cell B3, and we will extract the middle portion from it.

After that, we need to apply the above-mentioned formula in order to get the result in the spreadsheet.

To execute the function, you need to click on the Enter button and get the extracted value, as shown in the below image.

Let’s see one more example to make it clear for you. Here, we come up with the range of input values. The input range is B3:B6.

After that, you will get the results, as shown in the below screenshot.

A Short Synopsis

Hope this blog helped you to know about the MID Function in Excel. Please leave your Queries in the comment section, we will resolve your queries ASAP. Share your Feedback as well, it helps to enhance our write-up. To learn more about Excel functions, then visit our webpage Aawexcel.com.