The MID function is used to extract a specific number of characters from the middle of a cell.
This can be useful to when needing to remove unwanted characters in a cell that appear on the left and right of the cells content. This can happen as a result of importing data into Excel from another application or database.
The syntax for the MID function is:
=MID(text, start_num, num_chars)
|Text||The data containing the characters you want to extract|
|Start_num||The number of the first character you want to extract|
|Num_chars||The number of characters to the right of start_num that you want to extract|
The example below shows the MID function being used to extract the second and third characters from the content of cell A1.