mid

 The MID function in Excel is used to extract a specific number of characters from a text string, starting at a specified position. Below are 10 examples of how to use the MID function, including data and formulas.

Example 1: Basic MID Function

Data:
A1: Hello World

Formula:
=MID(A1, 7, 5)
Result: World
Explanation: Extracts 5 characters starting from the 7th character.

Example 2: Extracting Middle Characters

Data:
A1: ExcelFunctions

Formula:
=MID(A1, 6, 4)
Result: Func
Explanation: Extracts 4 characters starting from the 6th character.

Example 3: Extracting from a Specific Position

Data:
A1: 123-456-7890

Formula:
=MID(A1, 5, 3)
Result: 456
Explanation: Extracts 3 characters starting from the 5th character.

Example 4: Extracting a Single Character

Data:
A1: ABCDEFG

Formula:
=MID(A1, 4, 1)
Result: D
Explanation: Extracts 1 character starting from the 4th character.

Example 5: Extracting from a Date String

Data:
A1: 2023-10-05

Formula:
=MID(A1, 6, 2)
Result: 10
Explanation: Extracts the month part (2 characters) starting from the 6th character.

Example 6: Extracting from a Long Text

Data:
A1: The quick brown fox jumps over the lazy dog

Formula:
=MID(A1, 11, 5)
Result: brown
Explanation: Extracts 5 characters starting from the 11th character.

Example 7: Extracting with a Variable Start Position

Data:
A1: DataAnalysis
B1: 5

Formula:
=MID(A1, B1, 4)
Result: Anal
Explanation: Extracts 4 characters starting from the position specified in B1 (5).

Example 8: Extracting with a Variable Length

Data:
A1: Programming
B1: 4

Formula:
=MID(A1, 3, B1)
Result: ogra
Explanation: Extracts 4 characters (length specified in B1) starting from the 3rd character.

Example 9: Extracting from a Concatenated String

Data:
A1: Hello
B1: World

Formula:
=MID(A1 & B1, 6, 5)
Result: World
Explanation: Concatenates A1 and B1, then extracts 5 characters starting from the 6th character.

Example 10: Extracting from a Formula Result

Data:
A1: 12345
B1: 67890

Formula:
=MID(A1 & B1, 4, 6)
Result: 456789
Explanation: Concatenates A1 and B1, then extracts 6 characters starting from the 4th character.

Summary

The MID function is versatile and can be used in various scenarios to extract specific parts of a text string. By combining it with other functions or using variables for start position and length, you can create more dynamic and powerful formulas.