![]() |
|
#1
|
||||
|
||||
![]() 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. |
#2
|
|||
|
|||
![]()
Thank you that worked for all Alpha, do you know of a formula for Alpha Numeric with the same 3 character contraint?
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Gwen Butler | Office | 2 | 09-29-2011 06:10 AM |
![]() |
Wskip49 | Word | 5 | 08-28-2011 07:54 PM |
![]() |
stnicholas81 | Excel | 1 | 07-25-2011 01:31 AM |
Document unique numbering / forms | JamesF | Word | 0 | 11-22-2010 03:52 AM |
![]() |
bignick270 | Excel | 1 | 05-17-2009 05:40 AM |