View Single Post
 
Old 07-19-2011, 01:25 AM
stnicholas81 stnicholas81 is offline Windows 7 32bit Office 2010 64bit
Novice
 
Join Date: Jul 2011
Posts: 1
stnicholas81 is on a distinguished road
Default [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
Reply With Quote