autofill non-number character

E

elaine

Does anyone knows whether we can autofill alphabet characters?
ie autofill :

a
b
c
d
e
f
g
h
i
j
k
l .... etc?
 
J

JE McGimpsey

Enter your alphabetic sequence as a Custom List (Tools/Options/Custom
Lists)
 
P

Pete_UK

One way is to enter this formula in A1:

=CHAR(ROW()+96)
or
=CHAR(ROW()+64)
if you want upper case letters.

Then just copy the formula down. It will only work for 26 characters,
then you will get other symbols. Use Paste Special to fix the values.

Hope this helps.

Pete
 
E

elaine

Thanks Pete!
very useful!!!!

Elaine.


Pete_UK said:
One way is to enter this formula in A1:

=CHAR(ROW()+96)
or
=CHAR(ROW()+64)
if you want upper case letters.

Then just copy the formula down. It will only work for 26 characters,
then you will get other symbols. Use Paste Special to fix the values.

Hope this helps.

Pete
Click to expand...
 
G

Gord Dibben

Elaine

Stick this formula in B1 and drag/copy down 26 rows or 256 rows if you want to
go to IV

=SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")

I agree with J.E. that you should copy the a-z into your Custom Lists in
Tools>Options

Then you can autofill without any formulas.


Gord Dibben MS Excel MVP
 
R

RagDyeR

Hey Gord,

How about putting the 2 together?

http://tinyurl.com/kgx65

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Elaine

Stick this formula in B1 and drag/copy down 26 rows or 256 rows if you want
to
go to IV

=SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")

I agree with J.E. that you should copy the a-z into your Custom Lists in
Tools>Options

Then you can autofill without any formulas.


Gord Dibben MS Excel MVP
 
E

elaine

Thanks JE and Gord and Pete!! All very useful tips! didnt know that
theres a custom function before!!

elaine.
 
Top