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$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$1,RANDBETWEEN(1,26),1)
D1 =C1&B1
E1 =MID(D1,RANDBETWEEN(1,6),17)
BCDE四列往下复制2200份,E列就是你要的
追问能生成给我吗
不会弄
追答打开一张新sheet,把我给你的直接复制填到ABCDE五个格里面,选中BCDE四个格,点中右下角往下拖
追问你帮我做好 我下载!我来采纳你的答案好吗大哥帮忙
追答我这里不能上传东西到外网,这么简单的东西如果你不会,那么给你你也没法用啊