Excel MID Function: Syntax, Examples & Tips

text:
The text string from which you want to extract a substring. This can be a text string, a cell reference containing text, or a formula that returns text.

start_num:
The position of the first character you want to extract from the text. The first character in the text string is at position 1.

num_chars:
The number of characters you want to extract from the text, starting from the position specified by start_num.

What is a MID Formula in Excel?

The MID function in Excel is a text manipulation tool that allows you to extract a specific number of characters from a text string, starting at a designated position. This function is particularly useful when you need to isolate a portion of text from a larger string, making it easier to analyze or manipulate data.

In simpler terms, the MID function helps you extract substrings from text, which can be essential for data cleaning and formatting tasks.

A Practical Example

Imagine you have a list of product codes in an Excel spreadsheet, and you want to extract the model number from each code.

Product Codes Table:

You want to extract the model number, which is the four characters starting from the fifth position in each product code.

MID Formula

To extract the model number from the product codes, you would use the MID formula as follows:

=MID(A2, 5, 4)

Breakdown of the Formula:

• A2: This is the cell containing the text string (product code) from which you want to extract characters.
• 5: This is the starting position in the text string from which to begin extracting characters.
• 4: This is the number of characters to extract from the starting position.

Result of the Formula

When you apply the formula to each product code, it extracts the model numbers as follows:

Here, the extracted model numbers correspond to the four characters starting from the fifth position in each product code.

Why Use MID?

The MID function is particularly useful when you need to extract specific parts of text strings for analysis or reporting. It allows you to manipulate text data efficiently without the need for complex formulas or manual editing.

Key Takeaways:

• MID: Extracts a specified number of characters from a text string, starting at a defined position.
• Efficient Text Manipulation: Helps you isolate and analyze specific portions of text data.
• Common Use Cases: Ideal for parsing codes, cleaning data, and any scenario where you need to extract substrings from larger text strings.

Understanding how to use the MID function can significantly enhance your data manipulation capabilities in Excel, enabling you to work more effectively with text data.

Happy extracting!