fill series with alphabetic
 

hi community

can community assist me in this task,

i wanted to fill series, say, I place alphabet letter, "a", in one cell and
when I drag downwards or sideways, it will display, say, I drag away with 5
cells, it will display,

a b c d e f...

is this possible?

i tried using the Series dialog box on "linear" , "Growth", it does not
work???

or is it not possible to do such action, cause Excel only able to do with
numeric data?

thanks community for the assistance given

:)


--
oldLearner57

fill series with alphabetic
 

in A1:

=CHAR(ROW()+96)

then copy down

fill series with alphabetic
 

10s! :) Jarek Kujawa much appreciated

thanks community as well :)
--
oldLearner57


"Jarek Kujawa" wrote:

in A1:

=CHAR(ROW()+96)

then copy down

fill series with alphabetic
 

Check out these old posts.

The first describes how to set-up A to Z.

The second describes how to go beyond Z, to AA, AB, AC ... to maybe SA, SB,
SC ... etc.

http://groups.google.com/group/micro...5911fc66478752

http://groups.google.com/group/micro...8a0b7118ec0725

--

HTH,

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

"oldLearner57" wrote in message
...
10s! :) Jarek Kujawa much appreciated

thanks community as well :)
--
oldLearner57


"Jarek Kujawa" wrote:

in A1:

=CHAR(ROW()+96)

then copy down