![]() |
|
#8
|
||||
|
||||
|
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] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Word 2007 TOC Section Number w/Alpha Prefix?
|
Gwen Butler | Office | 2 | 09-29-2011 06:10 AM |
Place pages in alpha order.
|
Wskip49 | Word | 5 | 08-28-2011 07:54 PM |
[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 |
creating unique numbers in excel
|
bignick270 | Excel | 1 | 05-17-2009 05:40 AM |