Set up a User-defined function, and then copy it down. It will take
quite a while to calculate 200,000 times.

Pete

On Feb 13, 11:52*pm, 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