| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fill alphabetic series in excel
Like down a column?
I'd use this formula =SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","") and copy down. Then I'd convert it to values (edit|copy, edit|paste special|values) Pawan arora wrote: Hi I am not able to do alphabetic series in excel. etc A.......Z,AA,AB,AC please help me out from this. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO USE FILL SERIES | New Users to Excel | |||
| Series equivalent in Excel 2000 | Charts and Charting in Excel | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
| Make an Excel series of first and third fridays of each month? | Excel Discussion (Misc queries) | |||
Hybrid Mode
