身份证号码如何提取出星座和生肖
- 生活常识
- 关注:3.01W次
1、创建一个新的表格,在表格中输入身份证号码,将根据身份证号码导出生肖和星座。
2、在属性下面输入【=CHOOSE(MOD(MId(F7,7,4)-1900,12)+1,"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")】,回车就可以看到属性了。
3、用填充手柄把剩余的单元格都填充好。
4、在星座下面输入【=VLOOKUP(--TEXT(MId(F7,11,4),"2015-00-00"),{0,"摩羯";42024,"水瓶";42054,"双鱼";42084,"白羊";42114,"金牛";42145,"双子";42177,"巨蟹";42208,"狮子";42239,"处女";42270,"天秤";42301,"天蝎";42330,"射手";42360,"摩羯"},2)】,回车就可以看到星座了。
5、用填充手柄把剩余的单元格都填充好。
- 文章版权属于文章作者所有,转载请注明 https://mdbkg.com/sheng/8xod85.html