MID formula extracts a character/Text from a text on the base of given parameters.
Syntax for MID formula
MID( text, start_num, num_chars )
Parameters Details:
- text: The string that you wish to extract from.
- start_num: The position in the string that you will begin extracting from. The first position in the string is 1.
- num_chars: The number of characters that you wish to extract.
Returns
The MID function returns a string/text value.
