autofill non-number character

[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?

 

[JE McGimpsey]

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

 

[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

 

[elaine]

Thanks Pete!
very useful!!!!

Elaine.

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

 

[Pete_UK]

You're welcome, Elaine.

Pete

Thanks Pete!
very useful!!!!

Elaine.

 

[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

 

[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

 

[Gord Dibben]

I'll keep it in mind.

Too early in the day to start vibrating the synapses.

Hey Gord,

How about putting the 2 together?

http://tinyurl.com/kgx65

Gord Dibben MS Excel MVP

 

[elaine]

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

elaine.