I want to create a list in a column that just uses the alphabet....What should I do?
B BethfromNJ Nov 13, 2007 #1 I want to create a list in a column that just uses the alphabet....What should I do?
P pinmaster Nov 13, 2007 #2 Hi, You can use this for lower case letters: =CHAR(96+ROW(A1)) copy down if you want upper case letters then use 64 instead of 96 HTH Jean-Guy
Hi, You can use this for lower case letters: =CHAR(96+ROW(A1)) copy down if you want upper case letters then use 64 instead of 96 HTH Jean-Guy
P Peo Sjoblom Nov 13, 2007 #3 It's probably better to create a list in alphabetical order with then letters, then select it, then do tools>options>custom lists and import and add it. After that you only have to type in a or A and copy it down and it will return a list -- Regards, Peo Sjoblom
It's probably better to create a list in alphabetical order with then letters, then select it, then do tools>options>custom lists and import and add it. After that you only have to type in a or A and copy it down and it will return a list -- Regards, Peo Sjoblom
