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?
|