根据身份证求省市excle宏代码,加载宏以后。利用函数=sfz(A2,"QD"),=sfz(A2,"XB"),=sfz(A2,"SR")分别求籍贯、性别、生日。身份证号码存入A2单元格