How to extract the year, month and day from the ID card in excel

Extraction method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=mid (number column to be extracted, 7, 8)" in the cell, and press on the keyboard "Enter key" can extract the year, month and day in the ID card.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the employee information form that needs to be operated. The steps to operate the picture are as follows.

Enter =mid(B2,7,8) in cell C2 and press Enter on the keyboard to extract the year, month and day data in the ID card. The steps to operate pictures are as follows.

Through the Excel table function, you can copy the format of the cell by pulling the cell. The steps to operate the picture are as follows

After completing the above steps, you can extract the data of the ID card and extract the year, month and day data in the ID card. The operation picture is as follows.

Related learning recommendations: excel tutorial

The above is the detailed content of How to extract the year, month and day from the ID card in excel. For more information, please follow other related articles on the PHP Chinese website!