Random numbers and letters

[SJones]

I'm trying to use Excel to generate one-time passwords
with random numbers and letters. Numbers are easy
enough, but how can I use RAND to do letters, preferable
upper and lower case?

 

[Peo Sjoblom]

Put all the letters in a column, in (preferably) an adjacent column put

=RAND()

copy down alongside the letters, now sort by the
rand column and select the first n rows from the letter column

Regards,

Peo Sjoblom

 

[Tushar Mehta]

See Generate a random alphanumeric password
http://www.tushar-mehta.com/excel/tips/rand_alphanum.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Have the letters of the alphabet in a column say I, in H put asending numbers
e.g.

H I
------------------------
1 A
2 B
3 C and so on until 26 = Z

Where you want the random letters to be generated put in a VLookup like this

Cell A1 =Vlookup(randbetween(1,26),$H$1:$I$26,2,false)
This will give u a random letter, copy this formula in the cells where you
want to generate the passoword.

 

[Jason Morin]

1. List all characters in A1:A62.
2. Press Ctrl+F3.
3. In "Refers to:" put:
=INDEX($A$1:$A$62,RANDBETWEEN(1,62))
and give it the name "rnd" (no quotes).
4. In an open cell put:
=rnd&rnd&rnd&rnd&rnd&rnd

This will produce a 6 char. password. Also note that in
order to use RANDBETWEEN, you must have the Analysis
ToolPak loaded under Tools > Add-Ins.

HTH
Jason
Atlanta, GA