What is MID?
Extracts characters from the middle of a text string. The most versatile text extraction function for parsing structured data.
Syntax
=MID(text, start_num, num_chars)
Example
Formula: =MID(A1, 4, 5)
Result: Excel
How It Works
Returns 5 characters from A1, starting at position 4. If A1 contains 'MS Excel Pro', starting at character 4 and taking 5 characters gives 'Excel'.