Autofill Text

[Guest]

I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but find that I cannot autofill unless the series contains numbers or dates. Can any one suggest a simple answer for this as I am not an experienced user of EXCEL. It seems that filling in each series individually is the answer but it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers

 

[Paul]

I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but

find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers

I think you need to create a "custom fill series" for this sort of thing.
Full details are in Help.

 

[Max]

One way?

Say, to fill the series aaa - aaz

Put in say, B1: ="aa"&CHAR(ROW()+96)

Copy B1 down 26 rows to B26

B1 to B26 returns aaa - aaz

Above uses the "a" to "z" returns by char(97) to char(122),
viz if you put in a cell : =CHAR(97) >> it returns "a"

ROW() - which returns the row ref,
is used as an incrementer
(e.g.: ROW() in B1 returns "1")

So, just adjust accordingly the formula depending on
where you want to fill the series down from
(the total inside CHAR(..) must equal 97)

--
hth
Max
-----------------------------------------
Please reply in thread
Use xdemechanik <at>yahoo<dot>com for email
---------------------------------------------

I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but

find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers

 

[Arvi Laanemets]

Hi

When starting from cell A1:
A1=CHAR(INT((ROW(A1)-1)/676)+97)&CHAR(MOD(INT(((ROW(A1))-1)/26),26)+97)&CHAR
(MOD((ROW(A1)-1),26)+97)
and copy down

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but

find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers

 

[Max]

Marvellous one, Arvi!

Gives me a hell of a headache
trying to figure how it works, though <g>

Rgds,
Max