Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-07-2012, 01:06 PM
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

Yes, 0 to 9 gives 10 extra characters so 36^3 = 46656

A1 =ROW()-1 and fill down to A46656
B1 =MOD(A1,36)+IF(MOD(A1,36)<26,65,22)
C1 =INT(MOD(A1/36,36))+IF(INT(MOD(A1/36,36))<26,65,22)
D1 =INT(MOD(A1/36/36,36))+IF(INT(MOD(A1/36/36,36))<26,65,22)
E1 =CHAR(B1)&CHAR(C1)&CHAR(D1)


If case sensitive then you could also include lower case alpha which would then give you 238328 unique codes. I'll let you have a try at that one.
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 02:38 PM.


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