Summary

The Excel MID function returns a specified number of characters from the middle of a text string. You choose where to start and how many characters to take. For example, =MID("ABC-123-XYZ",5,3) returns "123".

MID is the most flexible of the three basic extraction functions. LEFT starts from the beginning, RIGHT starts from the end, and MID can start anywhere you specify.

Syntax

=MID(text, start_num, num_chars)

MID needs three arguments. text is the source value. start_num tells Excel where to begin. num_chars tells Excel how many characters to return from that position.

Arguments

• text - [Required] The text string or cell reference to extract from.
• start_num - [Required] The position of the first character to return. Position 1 is the first character.
• num_chars - [Required] The number of characters to return.

MID vs Other Functions

Use the extraction function that matches where your target text sits in the string. MID is the best choice when the text is in the middle or when the start position has to be calculated.

Using MID

MID works well when the segment you need always begins at the same position. If a code always stores the year in characters 5 to 8, MID can extract it directly with fixed numbers.

When the position changes from row to row, MID is often paired with FIND. FIND locates a delimiter such as a hyphen, and MID starts right after that delimiter. This makes the formula adapt to different prefix lengths.

• Use MID with fixed numbers when the text pattern is consistent.
• Use MID with FIND when the starting position depends on a separator.
• Remember that MID returns text, even if the extracted part looks numeric.

Example 1 - Extracting a Fixed Middle Segment

When the target segment always sits in the same place, MID is straightforward. You just give the start position and the number of characters to return.

=MID("ABC-123-XYZ", 5, 3) // "123"
=MID("ENG-2025-Q1", 5, 4) // "2025"

Example 2 - Pulling the Area Code from a Phone Number

If the phone number format is consistent, the area code is always in the same place. In (555) 000-1111, the three digits begin at position 2, so MID can return them directly.

=MID("(555) 000-1111", 2, 3) // "555"

Example 3 - Checking if a Middle Segment Matches

MID can sit inside a comparison or an IF formula when a certain segment of the string has meaning. That is useful for testing batch codes, department codes, or other structured parts of an identifier.

=MID(A4, 4, 3)="789"

=IF(MID(A4, 4, 3)="789", "Priority", "Standard")

Example 4 - Dynamic Extraction Using FIND

When the prefix length changes, a fixed start position will break. Using FIND lets MID calculate the correct starting point from the actual text, so the formula still works when the prefix gets longer or shorter.

=MID(A4, FIND("-",A4)+1, 3)
// "ID-789-X" -> "789"

MID works with text, numbers, and dates, but it always extracts from the stored text form of the value. If you need to extract from a displayed format, convert the value with TEXT first.

• All three MID arguments are required.
• Use FIND with MID when the cut point depends on a delimiter.
• If the extracted value should behave like a number, you may need to convert it afterward.

Conclusion Recap

• Summary: MID returns characters from any position in a text string.
• Syntax: =MID(text, start_num, num_chars).
• Key point: MID is best when the text you need is in the middle.
• Practical usage: Codes, year segments, area codes, and text between separators.
• Best pattern: Combine MID with FIND when the starting position is not fixed.