转载：EXCLE中如何选取身份证后几位
本帖最后由 清泠 于 2021-8-1 18:28 编辑方法/步骤1.打开excel并打开一份文档数据，其中B列就是身份证号，假设我们要提取身份证的后5位数字，看下怎么做https://exp-picture.cdn.bcebos.com/18aebc5f0c14c27b0416013d2a46b7b1eff93929.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
2.点击选中D2单元格，点击D2单元格，输入“=RIGHT(
https://exp-picture.cdn.bcebos.com/4d3d2ab33c4133ba33d584c96a37c97623bc2f29.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
3.按照提示我们先输入第一个参数，我们点击B2单元格。
https://exp-picture.cdn.bcebos.com/2a1ecb460596b8141f4432b743d246fe464e2229.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
4.第二个参数输入框上输入5，然后点击键盘上的回车键.点击D2单元格，可以看到有个蓝色的小方框，鼠标按住往下拉，拉到D12单元格后就放开，可以看到D列的数据已经得到正确的数据：B列身份证后5位数字。
https://exp-picture.cdn.bcebos.com/58021a0148fe1e4251fe8365c2299a8838130329.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80
页:
[1]