从身份证中识别性别=if(len(b2)=15,if(mod(value(right(b2,3)),2)=0,"女","男"),if(len(b2)=18,if(mod(value(mid(b2,15,1)),2)=0,"女","男"),"身份证错"))只要将单元格改成对应身份证号码所在单元格就行的就行
Excel身份证号提取性别
