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