如何用EXCEL制作壹組5000個，十位的，數字加字母的隨機碼（盡量不重復）？

在A1:A36中分別輸入0-9***10個數字和A-Z***26個字母，***36個字符。

在B1中輸入或復制粘貼下列公式

=INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))&INDEX(A:A,RANDBETWEEN(1,36))

下拉填充