良百科

枯榆绕屋，迎门绿竹。

用户工具

站点工具

  • write
  • everyday
  • yufa
  • poem
  • template
  • syntax
  • random
  • xiangfen
  • baidu
    • 您的足迹: • 如何在excel中把身份证号的出生年月提取
    抱歉，您没有权限增加页面
    blog:excel_studyjiqiao

    如何在excel中把身份证号的出生年月提取

    身份证号码都是现在都是18位的,从第7位到14位就是出生年月,在EXCEL中我们假设A1单元格是身份证号码,则你在B2输入=MID(A1,7,4)&“-”&MID(A1,11,2)&“-”&MID(A1,13,2)

    2017.2.16 (2021年8月31日21:08:11从有道云笔记导入）

    blog/excel_studyjiqiao.txt · 最后更改: 2021/08/31 21:08 (外部编辑)

    页面工具

    除额外注明的地方外，本维基上的内容按下列许可协议发布： CC Attribution-Share Alike 4.0 International
    CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

    ====== Title is entered here H1 ======

    ^ Article Info Card ^^^^

    ^ Original author | The internet ^ Original URL | [[http://www.jackboo.cn/wiki/ |Click to view]] |

    ^ Original source | The internet ^ Time of first publication | 2020.2.3 |

    ^ editor | jackboo yan ^Edit time| 20200203 |

    ^ Keywords | {{tag>Original}} ^ category | [[everyday]] |

    ^ Disclaimer | Just to spread knowledge, such as infringement, contact me, delete immediately --- ^^^

    ^ <randompage_link>More exciting, please click here!</randompage_link>^^^^

    video:<html> <iframe frameborder="0" src="https://weibo.com/343872060/" allowFullScreen="true"></iframe> </html>