随机17位数字+大写英文命令（可按需少几行） ``` =(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90)))) ``` 随机正整数：1-20元随机值＋000组成，即会生成1000-20000数字 ``` =RANDBETWEEN(1,20)&"000" ```