1、首先在电脑上打开需要编辑的Excel表格，进入到表格的首页中。
/iknow-pic.cdn.bcebos.com/b8014a90f603738d28944f42bc1bb051f919ecf0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b8014a90f603738d28944f42bc1bb051f919ecf0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b8014a90f603738d28944f42bc1bb051f919ecf0"/>
2、然后在“性别”栏输入公式“=IF(MOD(MID(A2,17,1),2),男，“女”）”，按下enter键确认。
/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd43fbbf151ae8b87d6277ff93c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd43fbbf151ae8b87d6277ff93c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd43fbbf151ae8b87d6277ff93c"/>
3、小提示：Mid函数提取数字，Mod函数判断奇偶，If函数判断男女性别，拖动“黑十字”鼠标向下拉即可。
/iknow-pic.cdn.bcebos.com/37d12f2eb9389b50b00ea3328a35e5dde6116ed9"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/37d12f2eb9389b50b00ea3328a35e5dde6116ed9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b50b00ea3328a35e5dde6116ed9"/>
4、然后这样就可以根据身份证号码提取性别了。
/iknow-pic.cdn.bcebos.com/37d3d539b6003af3ed659f003a2ac65c1138b6f7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/37d3d539b6003af3ed659f003a2ac65c1138b6f7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/37d3d539b6003af3ed659f003a2ac65c1138b6f7"/>