Alpha Numeric Codes

Hi All,

New to here, and i am in a bit of a pickle! I used to know the code for this, but can anyone paste up or point me toward the thread which gives you the formula for creating about 300 unique alphanumeric codes!! I know you have to type in 0123456789 Then ABC... etc in cell A1, then when i looked on here before someone had put up this formula that i pasted straight into A2!! Worked a charm but for the life of me i can't find that thread anymore!!

Anyone help??

Desperate from SE London!

Perhaps i should put an example up, these are a few codes from the previous spread sheet!

UW717F84
DW482Y23
UR830V78
FU454P79
BY92C542
DL630G10
ML541Q37
OI63L450
PW430Y89
OO306Y99
TF388J49
YF933F81
XQ186O82
OV421G93
RQ111O95
UN1071X1
PF484K47
XE307J18
LN961M38
TH300L35
CM313B56
UP463T94
OK232A25
GS230F13
VF388Q86
JF897F10
3K354W52
2W548Q67
5G336I89
6B604B51
0J1056O1
5C297V31
0H513T10
0X283G59

If anyone could help i'd be mightily pleased!

I have a solution now, just copy this into A1 and drag down to 300, glad i already done the one for 50,000!!

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(DEC2OCT(RAND()*10000000,8),"5","A"),"6","B"),"7","C"),"0","D")