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...