用EXCEL随机生成6-8位字母组合
=INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))
虽然有点长，但你可以看出是六位随机数并成的，如仍觉长，可以将10位数字，26*2个字母定义为一个区域，我这儿是一步到位
是如图意思吗？
=LEFT(CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(8,16))
输入
=CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHAR(INT(RAND()*24)+97)&CHOOSE(RANDBETWEEN(1,2),"",CHAR(INT(RAND()*24)+97))&CHOOSE(RANDBETWEEN(1,2),"",CHAR(INT(RAND()*24)+97))
得到6个随机小写字母，外加两个随机可能出现的小写字母或空格。
每位字母可按以下函数生成：
=HLOOKUP(RANDBETWEEN(1,26),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26;"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","u","v","w","x","y","z"},2)
然后用连接函数将各字母连接起来就行了。
建立一个宏，代码是
i = Round(Rnd() * 2) + 6
s = ""
For j = 1 To i
s = s & Chr(Round(Rnd() * 25) + 97)
Next
MsgBox s
用RAND函数
excel怎么生成随机数
在Excel中，有rand()函数可以生成随机数，只不过生成的范围是0-1之间。我们可以使用int来使随机数强制转换成整数，下面是随机生成2位数以及2位以上的数的方法。2位数n，则10=<n<=99，公式为"=INT(RAND()*90+10)"3位数为 "=INT(RAND()*900+100)"...6位数为"=INT(RAND()*900000+100000)...
excel中如何生成随机小数字?
工具\/原料：联想Y7000P Windows10 Microsoft Excel 2016 1、首先，在Excel中选择要生成随机数的一个区域，如下图所示，在此区域中生成10-100之间带有两位小数的随机数字。2、Excel中利用Randbetween函数可以生成指定范围内的整数，要生成小数，只要先生成整数，然后除以10的倍数即可。因此在Excel中输入公式=...
运用Excel生成随机数表并进行随机抽样
批量生成随机数表 一旦掌握了这个技巧，复制就变得简单。只需将生成的随机数拖动到所需的单元格，一列列、一行行地扩展，你就可以轻松构建出一张随机数表，满足任何抽样需求。无论是市场调查、数据分析还是游戏设计，Excel的随机数功能都能助你一臂之力。在Excel的世界里，每一个数字都带着一丝随机的...
如何在excel中随机生成数据
1、以下表为例，需要表格中随机生成50-100之间的随机数据。2、首先选中需要生成随机区域的单元格，选中后单元格会变成灰色。3、依次执行公式—插入函数。4、再插入函数面板类别选择数学与三角函数、randbetween后点击确定。5、在bottom（最小值）中输入50，在top（最大值）中输入100，点击确定。6、返回...
excel怎么随机生成一个数
1、演示使用的办公软件office Excel，软件的版本为office家庭和学生版2016，其他版本的office或WPS表格可以参考本操作。2、根据问题描述，我们在a1单元格中输入一个固定值。3、然后我们在任意一个单元格内输入得到随机值的函数，“=RAND()*24000-12000”，该函数产生的数值范围为-12000~+12000之间。4、...
excel 如何随机生成不重复的10个数
那就对1-10这10个数随机排序,然后随机赋给相应的单元格。 bqllda | 发布于2009-03-22 举报| 评论 0 0 =ROUND(1,10) shibuditou658 | 发布于2009-03-22 举报| 评论 0 0 其他2条回答 为您推荐: excel随机生成小数 excel函数公式大全 excel求和 excel随机数发生器 vba生成随机数不重复 ...
如何用Excel生成随机数?
可以利用迭代计算来解决这个问题，本文以用公式生成10个和值为1000，且范围在80-120之间的随机整数为例，说明Excel中用迭代计算的解决方法。1.启用迭代计算。在Excel2013中，单击“文件→选项→公式”，勾选“启用迭代计算”，根据实际需要调整“最多迭代次数”数量，本例为默认的“100”，将“误差”设...
如何在excel中随机生成数据
Excel中可以利用rand函数或者randbetween函数来实现随机生成数据。软件版本：Office2013 以Randbetween函数为例说明，方法如下：1.在A1-A10中随机生成1-100之间的数字，输入公式如下：2.下拉填充得到结果：注意事项：这些数字不是固定的，每次任意单元格更新或者按下F9，随机数字都会变化 ...
excel怎么在某一范围内生成随机数?
详情请查看视频回答
如何用EXCEL表格随机生成方程式?
首先，在EXCEL表格中设置两个单元格（例如A1和A2），每个单元格中都填写公式"=RAND()"。在另一个单元格（例如A3）中，使用简单的算术运算符生成随机方程式，例如"=A1+A2"。重复步骤2，生成更多的随机方程式。如果要生成整数方程式，可以使用ROUND函数，例如"=ROUND(A1+A2)"。请注意，这仅是一种简单...
柘哀玉液： =INDEX({1,2,3,4,5,6,7,8,9,0,＂a＂,＂b＂,＂c＂,＂d＂,＂e＂,＂f＂,＂g＂,＂＂,＂h＂,＂i＂,＂j＂,＂k＂,＂l＂,＂m＂,＂n＂,＂o＂,＂p＂,＂q＂,＂r＂,＂s＂,＂t＂,＂u＂,＂v＂,＂w＂,＂x＂,＂y＂,＂z＂},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,...
小店区17147906364： EXCEL中如何随机生成一列6位数字和字母组合.请高手列出公式 和详细使用方法,谢谢.我是小白？
柘哀玉液： 给你一个简单易懂的,只是长了一些,但已经是最好懂的了.解释在最下面. =MID(＂0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ＂,INT(RAND()*36)+1,1) 这会返回一个随机的数字或字母 =MID(＂0123456789...
小店区17147906364： 如何在EXCEL中随机函数26个英文字母? - ？
柘哀玉液： 大写字母 =CHAR(RAND()*26+65) 小写字母 =CHAR(RAND()*26+97)笨一点的公式就是 大写字母 =LEFT(ADDRESS(1,RAND()*25+1,4)) 小写字母 =LOWER(LEFT(ADDRESS(1,RAND()*25+1,4)))
小店区17147906364： 如何用Excel批量生成6位大写字母+数字的随机字符?？
柘哀玉液： 需要用到几个函数 生成大写字母可以用CHAR()函数,A-Z对定的参数是65-90 比如CHAR(65)=＂A＂,CHAR(90)=＂Z＂ 生成65-90之间的随机整数可以用RANDBETWEEN(65,90) 把数字和字母组合成一个字符串可以用＂&＂ 你可以根据你的需要灵活应用这几个函数 A1-A100: =＂A＂&RANDBETWEEN(1,100) A-Z: =CHAR(RANDBETWEEN(65,90))
小店区17147906364： EXCEL中如何随机生成一列20位数字和字母组合.请高手列出公式 和详细使用方法,谢谢.我是小白？
柘哀玉液： 鼠标点击输入框,闭上你的双眼,手指轻轻放在键盘上,随机按,那样就随机生成数字与字母了.(按的时候,心里要计算按了20次)
小店区17147906364： excel随机产生6位字符,其中要包含2个数字4个字母(小写的吧) - ？
柘哀玉液： 随机产生大写英文字母 =CHAR(INT(RAND()*24)+65) 随机产生小写英文字母 =CHAR(INT(RAND()*24)+97)随机产生大小写英文字母 =CHAR(INT(RAND()*24)+if(INT(RAND()*2)=0,65,97))或者编段程序: 按ALT+F11组合键,调出VBA窗口,插入...
小店区17147906364： excel生成7位数字一位字母的随机码 - ？
柘哀玉液： =REPLACE(RIGHT(INT(RAND()*1000000000),8),INT(RAND()*7),1,CHAR(RANDBETWEEN(65,90))) 你用这个试试 步骤是这样的,先取一个10位的联机数字 从右选取数字的8位 在8位数字中,随机位置Replace一位字母 字母的随机取值可以用...
小店区17147906364： 如何在EXCEL中生成八位数的大写字母加数字的随机字符串? - ？
柘哀玉液： 展开全部=CONCATENATE(LOOKUP(RANDBETWEEN(1,31),{1,＂A＂;2,＂B＂;3,＂C＂;4,＂D＂;5,＂E＂;6,＂F＂;7,＂G＂;8,＂H＂;9,＂I＂;10,＂J＂;11,＂K＂;12,＂L＂;13,＂M＂;14,＂N＂;15,＂P＂;16,＂Q＂;17,＂R＂;18,＂S＂;19,＂T＂;20,＂U...
小店区17147906364： ABCDEFGHIJKLMNOPQRSTUVWXYZ EXCEL中如何在这些字母中随机生成一列不重复的6位字母组合?不重复 - ？
柘哀玉液： A1为字符串 ＂ABCDEFGHIJKLMNOPQRSTUVWXYZ＂=MID($A$1,INT(RAND()*25+1),1)&MID($A$1,INT(RAND()*25+1),1)...
小店区17147906364： 哥,怎么在EXCEL中生成八个字的英文随机字母 - ？
柘哀玉液： =CHAR(INT(RAND()*(122-97+1)+97)) 以上是生成一个的公式
