第1个回答 2013-12-21
在A1中输入或复制粘贴此公式=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))
或
=CHAR(96+RANDBETWEEN(1,26))&CHAR(96+RANDBETWEEN(1,26))
下拉填充本回答被网友采纳
第2个回答 2013-12-21
A1=INDEX({"sh","ch"},RANDBETWEEN(1,2))本回答被提问者采纳
第3个回答 2013-12-21
=CHOOSE(INT(RAND()*2)+1,"sh","ch")
按F9变化