Returns character(s) from a string based on starting index and length. In other words MID function offers a character(s) extraction method based on inputs. We will understand MID Function in detail with example as part of this article.
=MID(text, start_num, num_chars)
- text: a mandatory parameter, refers to a string or text from which characters needs to be extracted.
- start_num: a mandatory parameter, refers to starting point from which characters needs to be extracted. Should be a positive number.
- num_chars: a mandatory parameter, refers to number of characters need to be extracted from input string. It should be an integer and should not be greater than input text.
Notice the first formula where we are extracting 10 characters from input string starting from 1st character resulting “VBAOVERALL“. In second formula we are extracting starting from 11th character rest of the string by using LEN function.