EXCEL中利用身份证号输入个人信息的方法
作者：董宏
来源：《电脑知识与技术》2011年第30期
摘要：在行政、人事或学籍管理过程中，我们常常会遇到大量的个人信息录入任务，既繁琐又枯燥。但如果能够理清相关数据之间的关系，并利用Excel的公式、函数、自动填充等功能加以解决，就能起到事半功倍的效果。身份证号是每个职工、学生最重要的个人信息，其中包含了户籍所在地、出生年月、性别等信息。我们可以充分利用这些联系，实现个人信息的简单录入。
关键词：EXCEL；输入；个人信息；方法
中图分类号：TP311文献标识码：A文章编号：1009-3044(2011)30-7326-02
The EXCEL Use ID Card Number to Enter Personal Information Method
DONG Hong
(Shanxi Province Jinzhong City Taigu County School Teachers, Jinzhong 030800, China)
Abstract: In the administrative, personnel and management process, we often encounter a number of personal information into task, both tedious and boring. But if we can sort out the data related to the relationship between, and using the Excel formula, function, automatic filling functions to solve, can play a multiplier effect. The ID number is every worker, student's most important personal information, including census register location, date of birth, sex and other information. We can make full use of the contact, to achieve personal information to a simple entry.
本文来源：https://www.2haoxitong.net/k/doc/e406843a162ded630b1c59eef8c75fbfc67d94c3.html
文档为doc格式