Learn the functions and usage of the MID function in Excel with the most detailed examples

Functions in Excel assist users in working more quickly and easily on computers. In today’s article, FPT Shop will guide you on how to use the MID function, one of the most commonly used functions in Excel, along with detailed examples.

Function of the MID function in Excel

The MID function is one of the common functions in Excel used to extract a part of the data in a specified character string.

The MID function in Excel has the following formula: MID (Text, Start_num, Num_chars)

Where:

• Text: The character string or cell containing the character string you want to extract a part of the data from. If it is a character string, it needs to be enclosed in double quotation marks, for example: “FPT Shop”.
• Start_num: The position of the starting character to extract.
• Num_chars: The number of characters to be extracted.

Note: In some versions of Excel, the comma “,” is replaced by a semicolon “;” in the formula of functions. Therefore, if you use a comma “,” and Excel displays an error, try changing it to a semicolon “;” immediately.

Common uses of the MID function

Basic data separation

Usually, the naming convention and total number of characters of product codes, orders, or customers are specific to each business. These codes often contain both letters and numbers, each part having its own meaning. For example, cell B5 contains information about a customer with the code 0123 who belongs to consumer group A. To extract the code 0123 from the given string, you can use the following formula: =MID(B5,3,4). This is a basic example of using the MID function, which can be applied in many cases where data separation is needed in a simple way.

You may also like

What are Excel formulas? Learn how to write and use Excel formulas effectively

Join FPT Shop to explore what Excel’s difference symbol is, how to write it, and how to use the difference symbol in Excel to compare data quickly and easily.

What is the TRUNC function in Excel? How to use the TRUNC function to round numbers to integer in a super easy way

In this article, we will delve into the details of the TRUNC function in Excel, an important tool in dealing with numerical data. We will explore how this function removes the decimal part, retains the integer part, and how it can be seamlessly integrated into the spreadsheet workflow.

15 Must-Know Excel Tricks for Accountants and Office Professionals

Excel is a widely used software tool among office workers. However, not everyone knows how to maximize their productivity while minimizing their working time. In this article, FPT Shop will reveal some incredibly useful Excel tricks to help you achieve that.