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)
Argument | Purpose |
---|---|
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.
