[How To] Generate Alpha Numeric Values in Excel 2010

[stnicholas81]

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

For example ab123456

Would greatly appreciate any form of advice.

Cheers,
Nic

 

[VoG]

Try

=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&TEXT(RANDBETWEEN(1,100000),"000000")

 

[Michael M]

Hi Nic and welcome to the Board
In column "A" starting at A1, put the numbers 1 to 9.
Directly after that put the letters of the alphabet from A to Z
Then in a cell somewhere else place the formula below

=INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))&INDEX($A$1:$A$36,RANDBETWEEN(1,36))