如何从字符串 abcdefghi 中随机选取4个字符?答:假设字符串在A1单元格,在B1单元格输入公式=MID(A1,RANDBETWEEN(1,LEN(A1)),1)&MID(A1,RANDBETWEEN(1,LEN(A1)),1)&MID(A1,RANDBETWEEN(1,LEN(A1)),1)&MID(A1,RANDBETWEEN(1,LEN(A1)),1)
excel随机选字符答:输入公式:=CHOOSE(RANDBETWEEN(1,5),"北京","上海","成都","南京","重庆")&" "&CHOOSE(RANDBETWEEN(1,5),"北京","上海","成都","南京","重庆")
怎样用Excel随机函数rand()生成随机数字和大写字母,能自动产生4位混合...答:思路:先构建一个序列,1-36,右列录入为A-Z字母,0-9数字。随机字符使用randbetween()和vlookup()共同完成。字符之间使用&连接。公式为:其中$N$1:$O$26为构建的序列 =VLOOKUP(RANDBETWEEN(1,36),$N$1:$O$36,2,0)&VLOOKUP(RANDBETWEEN(1,36),$N$1:$O$36,2,0)&VLOOKUP(RANDBETWEEN(1,...