50分求excel公式,解决再追加50分答:要找个好方法,但是还是用了这个 IF(A1=3,"07:"&TEXT(RANDBETWEEN(1,59),"00")&",11:"&RANDBETWEEN(30,59)&";12:"&RANDBETWEEN(31,59)&",17:"&RANDBETWEEN(30,59)&";"&IF(RANDBETWEEN(18,21)=21,"21:"&TEXT(RANDBETWEEN(0,29),"00"),RANDBETWEEN(18,20)&":"&TEXT(RANDBETWEEN(...
在Excel如何产生一个包含3个字符的字符串?(数字、大小、字母都可以...答:数字小写:=RANDBETWEEN(100,999)数字大写:=TEXT(RANDBETWEEN(1,9),"[dbnum2]")&TEXT(RANDBETWEEN(1,9),"[dbnum2]")&TEXT(RANDBETWEEN(1,9),"[dbnum2]")字母小写:=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))字母大写:=CHAR(RANDBETWEEN(65,90))&...
Excel生成一列17位的字符!要求:需要2200组,前面6到11位是字母后面是数字...答:A1 = ABCDEFGHIJKLMNOPQRSTUVWXYZ B1 =TEXT(RANDBETWEEN(0,99999999999),"00000000000")C1 =MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A...