Excel、wps表格带代码简单一键复制解决省时

多重格式组合一

QQ截图20181006161105.png

其他简单操作除组合,组合代码:=CONCATENATE(A2,B2,C2)

身份证出生、年龄、性别、星座、生肖提出

QQ五笔截图未命名.png

表格代码如下(红色改你想要):

出生:=MID(A2,7,4)&"年"&MID(A2,11,2)&"月"&MID(A2,13,2)&"日"

年龄:=YEAR(TODAY())-YEAR(B2)

性别:=IF(MOD(MID(A2,17,1),2),"男","女")

星座:=VLOOKUP(--TEXT(MID(A2,11,4),"2015-00-00"),{0,"摩羯";42024,"水瓶";42054,"双鱼";42084,"白羊";42114,"金牛";42145,"双子";42177,"巨蟹";42208,"狮子";42239,"处女";42270,"天秤";42301,"天蝎";42330,"射手";42360,"摩羯"},2)

生肖:=CHOOSE(MOD(MID(A2,7,4)-1900,12)+1,"鼠","牛","虎","兔","龙","蛇","马","羊","猴","鸡","狗","猪")

本博客所有文章归地球者:ALIN迷茫复制或转载请以超链接形式注明转自 北纳星_52bnx.cn
原文地址《Excel、wps表格带代码简单一键复制解决省时

相关推荐

发表评论

路人甲

网友评论(0)