Excel生成随机字符串的方法

2017 年 04 月 16 日

1103 次浏览

1469字数

一、单个字符的生成


	 

<pre class="prettyprint linenums">①随机小写字母：一位
=CHAR(INT(RAND()*25+97))
②随机大写字母：一位
=CHAR(INT(RAND()*25+65))
③随机数字：一位
=CHAR(INT(RAND()*9+48))</pre>
二、组合生成

	 


	随机生成10位字符串（数字，大写字母的方法）


<pre class="prettyprint linenums">=CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))&
CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90)))</pre>


<pre class="prettyprint linenums">=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))))</pre>

Excel生成随机字符串的方法