View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gretchen gretchen is offline
external usenet poster
 
Posts: 16
Default 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!