excel随机6位数,excel随机生成两位小数

Excel32位随机数 对于现在数据库中的ID或一些标识字段的32位随机数生产方法一方法二

对于现在数据库中的ID或一些标识字段的32位随机数生产

在添加程序中的数据的时候由于一些标识或者ID字段是必输的，随机手动编辑的话比较繁琐。最近找到了Excel中一些生产的方法，简单描述一下后续还会继续增加。

=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))))

=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))))

在方法二中是通过两部分完成的：
第一部分：**INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))**获取数字
第二部分：**CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))**获取字母

=INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))&INDEX({2,3,4,5,7,8,9},RANDBETWEEN(1,7))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91},RANDBETWEEN(1,24)))