Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A $43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEE N(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX ($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RA NDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43 ))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" wrote in
message ...

Is it possible to randomly generate an 8 alphanumeric string rather than
just numeric string. Numbers and alpha order should also be random,
purpose: trying to simulate password entries for test data


--
Pascale
------------------------------------------------------------------------
Pascale's Profile:
http://www.excelforum.com/member.php...o&userid=12546
View this thread: http://www.excelforum.com/showthread...hreadid=385434