Thread: how can I set up an alphabetic sequence?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default how can I set up an alphabetic sequence?
Assuming you start your letters in C2, you can use:

=CHAR(65+ROW()-ROW($C$2))

Ascii codes 65-90 give A-Z and codes 97-122 give a-z.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote