|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
CHAR(MID(SMALL(VALUE(((CODE(务工日记账!$D$5:$D$581)&CODE(MID(务工日记账!$D$5:$D$581,2,1))&IFERROR(CODE(MID(务工日记账!$D$5:$D$581,3,1)),"00000")))),ROW(A1)),1,5))&CHAR(MID(SMALL(VALUE(((CODE(务工日记账!$D$5:$D$581)&CODE(MID(务工日记账!$D$5:$D$581,2,1))&IFERROR(CODE(MID(务工日记账!$D$5:$D$581,3,1)),"00000")))),ROW(A1)),6,5))&IFERROR(CHAR(MID(SMALL(VALUE(((CODE(务工日记账!$D$5:$D$581)&CODE(MID(务工日记账!$D$5:$D$581,2,1))&IFERROR(CODE(MID(务工日记账!$D$5:$D$581,3,1)),"00000")))),ROW(A1)),11,5)),"")
我只会开火车 如果有名字有四字五字的还得更长 |
|