fill series with alphabetic


O

oldLearner57

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

:)
 
Ad

Advertisements

Ad

Advertisements

R

RagDyeR

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/microsoft.public.excel/msg/115911fc66478752

http://groups.google.com/group/microsoft.public.excel/msg/3a8a0b7118ec0725

--

HTH,

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

10s! :) Jarek Kujawa much appreciated

thanks community as well :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top