In the cell where you want to place the result type =MID(A3,4,2).. A3 is the string containing the characters you want to extract.. 4 is the position of the first character you want to extract.

This is great for cases where you know the length of the numbers, for example, telephone numbers or ID numbers. Keep reading to see how this is done and how you can put it to practical use. 1 ...