Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-07-2012, 11:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Unique 3 char Alpha Numberic column Windows 7 32bit Unique 3 char Alpha Numberic column 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unique 3 char Alpha Numberic column Word 2007 TOC Section Number w/Alpha Prefix? Gwen Butler Office 2 09-29-2011 06:10 AM
Unique 3 char Alpha Numberic column Place pages in alpha order. Wskip49 Word 5 08-28-2011 07:54 PM
Unique 3 char Alpha Numberic column [How To] Generate Alpha Numeric Values in Excel 2010 stnicholas81 Excel 1 07-25-2011 01:31 AM
Document unique numbering / forms JamesF Word 0 11-22-2010 03:52 AM
Unique 3 char Alpha Numberic column creating unique numbers in excel bignick270 Excel 1 05-17-2009 05:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft