Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alfabet
Hello,
Could anybody tell me how to create the alfabet without put the full 26 letters but in a way to do this quicker. Just like, Januari, Februari and 1, 2,3,4. I don't know if it is possible in excel. The way like counting did not work according me. thanks Marcel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
alfabet
In A1 enter:
=CHAR(ROW()+64) and copy down -- Gary''s Student - gsnu200764 "operator" wrote: Hello, Could anybody tell me how to create the alfabet without put the full 26 letters but in a way to do this quicker. Just like, Januari, Februari and 1, 2,3,4. I don't know if it is possible in excel. The way like counting did not work according me. thanks Marcel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
alfabet
You have to make a Custom List with a to z in it then it will work like the
months and numbers. ToolsOptionsCustom ListsAdd Enter a through z and OK Or add a through z in A1:A26 then use that as an "Import" range Gord Dibben MS Excel MVP On Wed, 9 Jan 2008 10:06:06 -0800, operator wrote: Hello, Could anybody tell me how to create the alfabet without put the full 26 letters but in a way to do this quicker. Just like, Januari, Februari and 1, 2,3,4. I don't know if it is possible in excel. The way like counting did not work according me. thanks Marcel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|