MID()
Returns characters from the middle of a text string, starting at a position you specify.
MID(text, start_num, num_chars)MID extracts num_chars characters starting at position start_num, counting from 1 at the left of the string. It's the tool for pulling a chunk out of the middle of consistently formatted text.
If start_num is beyond the end of the text, MID returns an empty string rather than an error.
Arguments
- text
- The text to extract characters from.
- start_num
- The position of the first character to extract, counting from 1.
- num_chars
- How many characters to extract from that position.
Examples
=MID("SKU-1049-BLK", 5, 4)→1049
Starts at position 5 and grabs the next 4 characters.