Formula Library
MID
textExtracts a specific number of characters from a text string, starting at a given position.
Syntax
=MID(text, start_num, num_chars)Example
Excel
=MID(A2, 4, 5)Returns 5 characters from A2, starting at the 4th character.
Tips & Notes
- →Often used with FIND to locate the starting position
- →Start position is 1-indexed
- →Combine with LEN to extract everything after a delimiter
See Also
Need a custom MID formula?
Describe exactly what you need and get the formula generated instantly.