Filling range of cells with alpha-numeric text

K

Ken

I need an easy way to create a large number of cells with
alpha-numeric text labels such as perfa, perfb, perfc,
perfd,... perfm, etc., timea, timeb, timec, ... etc.
This works with numeric series (perf1, perf2, etc.), and
I thought Excel would allow me to fill down a series and
it would simply follow the seemingly obvious pattern. (I
could swear that previous versions did this - I am
currently using Excel 97 on a WinXP PC). If I start with
the first few entries and fill down, I just get multiple
copies of the same 2 or 3 cells that I started the fill
with. Does anyone know how to do this?
 
R

Robert Rosenberg

Excel won't autofill alphanumerically - never did as far as I know.

Use can use the Tools-->Options-->Custom Lists Tab to add your own custom
list. These lists are used by when performing a custom sort order and when
copying data using AutoFill.
 
K

Ken Wright

Workaround only, but you can autofill using a,b,c,d etc, then use another helper column and a
formula such ="Perf"&A1 and copy down. Copy and paste as values and then delete the helper
column.
 
T

TBA

Robert Rosenberg said:
Excel won't autofill alphanumerically - never did as far as I know.
Click to expand...

Strange, it works for me, I do it all the time. I do a football pool and I
can type in Week01 and then drag and fill down to my hearts content. Works
every time.

-gk-
 
G

Gord Dibben

Krn

="perf" & CHAR(ROW()+96)..........CHAR(97) being "a"

Entered in A1 will return perfa. Copy down column A

Gord Dibben Excel MVP XL2002
 
T

TBA

Ken Wright said:
But take a look at what you have just written. Week01 filled down is a set of numbers at the end
of the text that will change, It's the alpha part that won't go here. The OP has already stated
that it works like that with his example of perf1, perf2 etc (same as your Wekk01 etc), but it's
the alpha part with perfa, perfb that won't autofill, just as Ron has stated.
Click to expand...

Doh! Need to brush up on my reading skills. Sorry for the bonehead reply.

-gk-
 
Top