How to use the WPS form to extract the ID date of birth in three seconds

As a staff member of information management, when entering data, sometimes it is necessary to extract the date of birth from the ID card number. If you do not want to manually enter one, what should I do? You don't have to learn cumbersome functions, you don't have to search the online template, use the WPS form, you can extract the date of birth from the ID number in just three seconds. Next, let's practice using the WPS form together. Steps: 1. Open the spreadsheet containing the ID number using the WPS form (ET). 2. Click into the date of birth cell, click “fx” or execute “insert function”, select “extract ID card birthday" in the "Common formula" tab, click to enter “ Enter the following box on the right side of the ID card number, click on the cell where the ID number is located or directly enter the cell name where the ID number is located, click “insert formula”, a birth The date is extracted successfully! 3. Perform autofill to extract the birth date of others. In this way, the date of birth data can be automatically displayed. This article comes from [System Home] www.xp85.com