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

Use mid function to extract employee birth date

angryTomOriginal: 2019-10-22 10:43:1935278browse

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!

字符串 excel

Statement：

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

Previous article：what is power queryNext article：what is power query

See more

Use mid function to extract employee birth date

Related articles