MID Function
The MID function selects a portion of the string to display beginning at value 1 characters from the left of the string for value 2 characters into the string. Value 2 is optional. If value 2 is not supplied, the function returns all remaining characters. This function is only applicable for alphanumeric cells.
Syntax
MID(expression,value1,<value2>)
Example
MID("Prince Edward Island",8,6)
Where 8 characters into the string is the E of Edward and 6 characters from the E of Edward is the last D of Edward. Therefore the cell displays Edward.
