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

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

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