excel如何根据身份证提取出生年月

excel如何根据身份证提取出生年月

回复
  • 姚思懿用户
    [[{"txt": "\u4ecb\u7ecdexcel\u5982\u4f55\u6839\u636e\u8eab\u4efd\u8bc1\u63d0\u53d6\u51fa\u751f\u5e74\u6708\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u7535\u8111"}, {"txt": "excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u6253\u5f00excel\u5de5\u4f5c\u8584\u5982\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/f591ab03c8d246fec1523230b8bf3bef344f1eb0.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u7a7a\u767d\u5355\u5143\u683c\u5185\u8f93\u5165TEXT,\u51fa\u73b0\u8be5\u51fd\u6570\uff0c\u53cc\u51fb\u9009\u62e9\uff0c\u5982\u56fe\u6240\u793a\u3002\u00a0"}, {"img": ["https://exp-picture.cdn.bcebos.com/3aae2b4f50b8b43e25c7a7f97132939c2df719b0.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u51fd\u6570\u62ec\u53f7\u5185\u8f93\u5165\uff08MID(B1,7,8),\"0-00-00\"),\u5982\u56fe\u6240\u793a\u3002\u00a0"}, {"img": ["https://exp-picture.cdn.bcebos.com/92dd32f7dfb2dc195a30aba895def4dca13910b0.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u56de\u8f66\u952e\u540e\uff0c\u8eab\u4efd\u8bc1\u7684\u65e5\u671f\u88ab\u63d0\u53d6\u540e\u7684\u7ed3\u679c\u5982\u56fe\u6240\u793a\u3002\u9009\u62e9\u8be5\u5355\u5143\u683c\u5185\u5bb9\uff0c\u5f80\u4e0b\u62d6\u62c9\u3002\u00a0"}, {"img": ["https://exp-picture.cdn.bcebos.com/f59dbe39131fceec48c599c679c4ec9958430bb0.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6240\u6709\u8eab\u4efd\u8bc1\u7684\u51fa\u751f\u5e74\u6708\u90fd\u53ef\u4ee5\u88ab\u63d0\u53d6\uff0c\u5982\u56fe\u6240\u793a\u3002\u00a0"}, {"img": ["https://exp-picture.cdn.bcebos.com/6834ecc4ec995943a41db84d95425d6b05d104b0.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "excel\u7248\u672c\u4e3a2007."}]]
    2024-11-23
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请