Excel > Functions

MID Function

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)




The data containing the characters you want to extract


The number of the first character you want to extract


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.

MID function being used to extract cell characters

Follow us on

Facebook  Twitter  You Tube 

Other Text Functions

Excel 2010 Superhero Course