how can I set up an alphabetic sequence?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can I have excel create a sequence in alphabetic letters as it does in
number sequences?
 
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
 
Once you have the list from a-z on your worksheet, go to Tools>Options>Custom
Lists and "Add" the a-z to the lists.

In future just enter a in A1, b in A2 then drag/copy down.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Define alphabetic sequence to sort by 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
All my folders are now in reverse alpha order. How can I fix? 4
Counting a series of text and/or numbers within columns 17
How do I autofill an alphabetic sequence? (AAA, AAB, etc.) 3
ordeing columns 1
How to autofill excel with an alphabetic sequence (aaa, aab, etc.. 3
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0

Back
Top