摘要
身份证号码与一个人的性别、出生年月、年龄等信息是紧密相连的,无论是15位还是18位的身份证号码,其中都保存了相关的个人信息,通过运用Excel自带的函数可以自动地提取出所需的有用信息。
The ID card number of a person＇s sex, date of birth, age and other information are closely linked, both 15-bit or 18-bit ID number, all of which preserve the relevant personal information through the use of Excel built-in function can be automatically extracted the required useful information.
