View Single Post
 
Old 03-07-2012, 11:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

The letters A-Z 3 times will give you 26^3 = 17576 unique codes.

In cell A1 =ROW()-1 and fill down to A17576
In cell B1 =MOD(A1,26)+65 and fill down to B17576
In cell C1 =INT(MOD(A1/26,26))+65 and fill down to C17576
In cell D1 =INT(MOD(A1/26/26,26))+65 and fill down to D17576
In cell E1 =CHAR(B1)&CHAR(C1)&CHAR(D1) and fill down to E17576

Column E gives you the unique alpha codes. Copy them and paste special to turn into constants. Then you can use them.
Reply With Quote