excel里随机生成数

excel里随机生成数

我又重新弄了一下，可以用函数解决，不过有点长：
假设十六个字串在D1单元格
组合单元格输入：=MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)&MID($D$1,INT(RAND()*16 1),1)
别被长公式吓着了，实际上就是一个：MID($D$1,INT(RAND()*16 1),1)，选上复制——粘贴26次，中间用“&”符号连起来就可以了。