Thread: [Solved] Unique 3 char Alpha Numberic column
View Single Post
 
Old 03-09-2012, 06:45 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Actually, they're already in a logical order, but perhaps it wasn't apparent. The order was the reverse of what might be expected. A more conventional order in column E would be gained by:
=CHAR(D1)&CHAR(C1)&CHAR(B1)

Alternatively, you could put the whole catastrophe into a single formula:
=CHAR(MOD((ROW()-1)/1296,36)+22+(MOD((ROW()-1)/1296,36)<26)*43)&CHAR(MOD((ROW()-1)/36,36)+22+(MOD((ROW()-1)/36,36)<26)*43)&CHAR(MOD(ROW()-1,36)+(MOD(ROW()-1,36)<26)*43+22)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote