In Excel, the mid function can be used to extract a specific string from a cell.

Software version: Office2007

The method is as follows:

1. Starting from the second bit of the cell in column A, extract 2 characters:

2. The input formula is as follows:

3. The drop-down filling results are as follows: