Generating a random 17-character alphanumeric string
Tyro:
I checked for dups after you responded.
Interestingly, I had no duplicates.
"Tyro" wrote:
Ten to one, you have duplicates
Tyro
"Dan" wrote in message
...
This is Dan again.
I found a similar question and Max answered it on 11/5/2006. It uses
=CHAR(randbetween.....&......) formula. I played around with it until it
worked.
Since I was in Excel 2007 and I had to get it compatable with Excel 2003,
I
had to play with it until I had 3 columns of alphanumerics, 60,000 rows
long.
Surprisingly, it did not take but a few seconds to calculate.
Thought I'd throw that in.
"Dan" wrote:
EXCEL 2007
I would like to generate a column of random 17-character alphanumeric
strings into cells A1:A100000. I'd also like to continue into column B:
eg;
B1:B100000 so that I have 200000 random VINs.
Can anyone help? I can think of some brute-force methods but I'm looking
for
an elegant solution. I think it can be done in one column with EXCEL
2007.
Thanks for any help.
Dan
|