Use mid function to extract employee birth date

Use the mid function to extract the employee’s date of birth

The mid function consists of three parameters, =mid (String, starting position, number of characters) , in this formula, we want to extract the data in cell A2.

1. Take the excel2010 version as an example. As shown in the figure, first enter the formula to extract the year in cell B2, =MID(A2,7,4)&"year". After the extracted number, If adding the text year, use the "&" symbol to connect;

2. Then enter the formula to extract the month in cell B2, =MID( A2,11,2)&"month", because month is the 11th digit on the ID card, so fill in 11 for the second parameter here, and then only take two digits;

##3. Finally, enter the formula for extracting the day in cell B2, =MID(A2,13,2)&"日";

4. After entering the formula, press the Enter key to successfully extract the employee’s date of birth. Place the mouse on the lower right corner of cell B1 and pull down to fill in the formula.

For more Excel-related technical articles, please visit the

Excel Tutorial Column to learn!

The above is the detailed content of Use mid function to extract employee birth date. For more information, please follow other related articles on the PHP Chinese website!