| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increment letters of the alphabet for a database
Howdy,
I use a database that contains an id field that is a 5 letter "code". So the first item in the database is AAAAA, the second is AAAAB, the third is AAAAC and so on until item 26 is AAAAZ. Item 27 is AAABA, then 28 is AAABB, then 29 AAABC and on and on. Is there a way for excel to increment all the letters up to ZZZZZ in seperate cells? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver - Assign values to the letters of the alphabet | Excel Discussion (Misc queries) | |||
| Solver - Assign values to Letters of the Alphabet | Excel Discussion (Misc queries) | |||
| Solver - Assign values to Letters of the Alphabet | Excel Discussion (Misc queries) | |||
| associate alphabet letters with numbers? | New Users to Excel | |||
| how to assign a value to the alphabet in order to add up letters | Excel Discussion (Misc queries) | |||
Threaded Mode
