The MID function is the trickiest of these text functions. It returns the specified number of characters from the middle of a text string. The syntax for the MID function looks like this:
=MID(text, start_num, num_chars).
Click in the cell where you want to insert the function.
Click the Formulas tab.
Click the Text Function button.
The Function Arguments dialog box opens where you specify the parameters.
In the Text field, select the cell containing text you want to extract.
In the Start_num field,enter the position of the first character you want to extract.
In the Num_chars field,enter the number of characters you want to extract, starting with the character specified in the previous field.
The text is extracted and the specified number of characters from the middle of the text string are placed in the current cell.