怎么在excel里面随机生成三种车型车架号

更新时间2022-04-30 08:11:07

因为都是工程运输车辆所以前面几位数分别为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)

结果

怎么在excel里面随机生成三种车型车架号

="LZFF25"&MID("WXT",RANDBETWEEN(1,3),1)&TEXT(RANDBETWEEN(0,99),"00")&CHAR(RANDBETWEEN(65,90))&"D"&TEXT(RANDBETWEEN(0,999999),"000000")