如何从字符串 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)