- Image and text skills
The 18-digit ID number contains a lot of information such as date of birth, gender, age, region code, etc. Use the automatic extraction function
can reduce the time of entering personnel information, so how to quickly extract the age based on the ID number?
￭ First select the cell in the "Age" column, then click the "Insert Function" button under the "Formulas" tab, and then select "Common Formulas" - "Extract ID Card" "Age", select the corresponding ID card number cell in the "Parameter column", click OK, and the age will be automatically calculated.
￭ Finally, select the cell where the age needs to be calculated, click the "Fill" button under the "Home" tab, select "Fill Down", or use the shortcut key " Ctrl+D" one-click fill, have you learned it?
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ren-shi-xing-zheng-ji-qiao-kuai-jie-gong-shi-gong-neng-ti-qu-shen-fen-zheng-nian-ling-xin-xi.html
支付宝扫一扫 
评论列表（196条）
测试