Excel function MID

You can used the MID function to extract part of a text string starting from a specified point (of your choice).

Let's try an example:

Cell A2 contains a reference.

We want to extract the number (in the middle) and display it in B2.

To do this, select the MID function from B2.

mid function

The function will now return characters 7 through 11: