alfabet

[operator]

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

 

[Gary''s Student]

In A1 enter:

=CHAR(ROW()+64) and copy down

 

[Gord Dibben]

You have to make a Custom List with a to z in it then it will work like the
months and numbers.

Tools>Options>Custom Lists>Add

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