The Excel MID function extracts a given number of characters from the middle of a supplied text string. For example, =MID(“apple”,2,3) returns “ppl”.
- Purpose: Extract text from inside a string
- Return value: The characters extracted.
=MID (text, start_num, num_chars)
- text - The text to extract from.
- start_num - The location of the first character to extract.
- num_chars - The number of characters to extract.
The formula below returns 3 characters starting at the 5th character:
=MID("The cat in the hat",5,3) // returns "cat"