隨機生成 4-6字元组合的字符串 (14360)

D2=LEFT(MID($B$2,RANDBETWEEN(1,LEN($B$2)),1)&MID($B$2,RANDBETWEEN(1,LEN($B$2)),1)&MID($B$2,RANDBETWEEN(1,LEN($B$2)),1)&MID($B$2,RANDBETWEEN(1,LEN($B$2)),1)&MID($B$2,RANDBETWEEN(1,LEN($B$2)),1)&MID($B$2,RANDBETWEEN(1,LEN($B$2)),1),RANDBETWEEN(4,6))

G2:L2 區域數組公式 下拉{=MID(B$2,RIGHT(LARGE(RANDBETWEEN(ROW(INDIRECT("1:"&LEN(B$2)))^0,999)/1%+ROW(INDIRECT("1:"&LEN(B$2))),COLUMN(A:F)),2),1)

E2=LEFT(G2&H2&I2&J2&K2&L2,RANDBETWEEN(4,6))