一、以提取身份证中的年月日为例,选中需要返值的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/503d269759ee3d6dadf39fc54c166d224f4ade83?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、选择菜单栏上方FX函数,在跳出来的对话框中搜索函数”MID“,这个函数的作用是:从文本字符串中指定的起始位置起返回指定长度的字符。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3812b31bb051f81956ff1a44d5b44aed2f73e7e2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、点击确认,在弹出的函数设置对话框内,在TEXT,点击或输入需要提取数据的单元格,这里就是”A2“。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9b0762cd73601213fb80e9160?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、在第二项,Start_num中,输入需要提取值开始的数字序号。在身份证中,出生日期开始的数字为第7个。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/91ef76c6a7efce1bcffcd1c4a051f3deb58f65ec?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、第三项,Num_chars中,输入需要提取数值的个数,也就是从第7位开始至结束的序数。身份证中,出生日期的数字一共有8个。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3b7d0a20cf431adfc045a374436acaf2fdd98ed?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
六、点击确认后,在单元格中就显示我们需要提取的出生日期了,操作完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfafc61dee0bb8f8c5494ee7baa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)