Home > Topics > excel > Use mid function to extract employee birth date

Use mid function to extract employee birth date

angryTom
Release: 2019-10-24 17:29:56
Original
35462 people have browsed it

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;

Use mid function to extract employee birth date

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;

Use mid function to extract employee birth date

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

Use mid function to extract employee birth date

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.

Use mid function to extract employee birth date

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template