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

关键字：excel 更新时间：2022-04-30 08:11:07 487次访问

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

相关标签：excel