Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I set up an alphabetic sequence?
how can I have excel create a sequence in alphabetic letters as it does in
number sequences? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I set up an alphabetic sequence?
Once you have the list from a-z on your worksheet, go to ToolsOptionsCustom
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 On 1 May 2006 09:15:23 -0700, "vezerid" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) | |||
How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) | |||
How do I autofill an alphabetic sequence? (AAA, AAB, etc.) | Excel Discussion (Misc queries) | |||
How to autofill excel with an alphabetic sequence (aaa, aab, etc.. | Excel Discussion (Misc queries) | |||
Formula for copying a sequence for every 8th cell | Excel Worksheet Functions |