Here is another way.
Put this in A1 (or give it a Name):
0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmn opqrstuvwxyz
Then copy this to A2:
=MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+IN T(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($ A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($ A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND ()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)), 1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)
Ola Sandström
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=385434