Typo....numbers are 48-57, as in the formula.



"Dave R." wrote in message
...
One way is to use RANDBETWEEN and CHAR(),

numbers are 47-59 and letters (cap) from 65-90.

So you might want to use a formula like this:

=CHAR(CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(48,57),R ANDBETWEEN(65,90)))

which will randomly give you a number or capital letter.. copy it to as
many
columns as you like, then create some formula like

=A1&B1&C1&D1&E1

to join them together (in that case a 5 character random alphanumeric
string).



"
wrote in message
...
Doe anyone know of a way to generate an alphanumeric string?