Excel如何从身份证号码中提取籍贯户籍信息

可以使用Excel的文本函数来从身份证号码中提取籍贯户籍信息，具体步骤如下：

1. 在Excel中新建一个列，命名为“籍贯”。

2. 在该列的第一行输入以下公式：=IF(MID(A1,11,2)="11","北京",IF(MID(A1,11,2)="12","天津",IF(MID(A1,11,2)="13","河北",IF(MID(A1,11,2)="14","山西",IF(MID(A1,11,2)="15","内蒙古",IF(MID(A1,11,2)="21","辽宁",IF(MID(A1,11,2)="22","吉林",IF(MID(A1,11,2)="23","黑龙江",IF(MID(A1,11,2)="31","上海",IF(MID(A1,11,2)="32","江苏",IF(MID(A1,11,2)="33","浙江",IF(MID(A1,11,2)="34","安徽",IF(MID(A1,11,2)="35","福建",IF(MID(A1,11,2)="36","江西",IF(MID(A1,11,2)="37","山东",IF(MID(A1,11,2)="41","河南",IF(MID(A1,11,2)="42","湖北",IF(MID(A1,11,2)="43","湖南",IF(MID(A1,11,2)="44","广东",IF(MID(A1,11,2)="45","广西",IF(MID(A1,11,2)="46","海南",IF(MID(A1,11,2)="50","重庆",IF(MID(A1,11,2)="51","四川",IF(MID(A1,11,2)="52","贵州",IF(MID(A1,11,2)="53","云南",IF(MID(A1,11,2)="54","西藏",IF(MID(A1,11,2)="61","陕西",IF(MID(A1,11,2)="62","甘肃",IF(MID(A1,11,2)="63","青海",IF(MID(A1,11,2)="64","宁夏",IF(MID(A1,11,2)="65","新疆",IF(MID(A1,11,2)="71","台湾",IF(MID(A1,11,2)="81","香港",IF(MID(A1,11,2)="82","澳门","未知")))))))))))))))))))))))))))))

3. 将公式复制到所有需要提取籍贯信息的单元格中，即可快速提取身份证号码中的籍贯户籍信息。

注：上述公式仅适用于18位身份证号码，14位身份证号码籍贯信息提取方式不同。