[How To] Generate Alpha Numeric Values in Excel 2010
Hi Guys,
I need some advice on generating random (no repeat) alpha numeric numbers in Excel for promotion code usage.
I have done this for numerals before but not for alpha numerals. I need 24,000 of these values.
Requirement:
- 8 values consisting of
- 2 alpha
- 6 numerals
- any sequence
Would greatly appreciate any form of advice.
Cheers,
Nic
|