问题:
怎么在excel里面随机生成三种车型车架号
因为都是工程运输车辆 所以前面几位数分别为L, Z ,F ,F ,2 ,5,( W 或则 X 或则T),数字,数字,大写字母,大写字母,数字。数字,数字,数字, 数字,数字 共计17位号码
求求哪位大神能给做出来三个公式 生成随机车架号 谢谢了!
示例:LZFF25T41HD008481
LZFF25X48LD036006
LZFF25W49HD038419
推荐答案:
公式为
=LZFF25&IF(RANDBETWEEN(1,2)=1,W,IF(RANDBETWEEN(1,2)=1,X,T))&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))& D &RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)
结果
其他答案:
=LZFF25&MID(WXT,RANDBETWEEN(1,3),1)&TEXT(RANDBETWEEN(0,99),00)&CHAR(RANDBETWEEN(65,90))&D&TEXT(RANDBETWEEN(0,999999),000000) |