Replicate and increment alphanumeric keywords?

Try in B1 copied across:

Please Login or Register  to view this content.

Originally Posted by shg

Just put seedword100 in any cell, grab the fill handle, and drag it down as far as you want ...

doh!! I don't know what I was thinking!

Yeah, that's much easier.

Originally Posted by NBVC

Try in B1 copied across:

Please Login or Register  to view this content.

That does not work for me. All I get is "#VALUE".

Originally Posted by shg

Just put seedword100 in any cell, grab the fill handle, and drag it down as far as you want ...

I'm sorry, I don't quite understand. If you are talking about using the "fill down" function, that does not work. All the does is fill down all specified fields with "seedword100" in all cells. it does not increment the "100".

Perhaps I am not understanding what you mean by "fill handle"?

BTW, I am using Excel 2000 so maybe I do not have a "fill handle"???

Also, I made a mistake in my initial post. WHere I said...

B1 = seedword101
C1 = seedword102
D1 = seedword103
E1 = seedword104
F1 = seedword105
G1 = seedword106
H1 = seedword107 ...

I meant to say...

A2 = seedword101
A3 = seedword102
A4 = seedword103
A5 = seedword104
A6 = seedword105
A7 = seedword106
A8 = seedword107 ...

But I think you all get the idea. I was thinking the right way in the wrong direction. Duh.

Hi toolsavvy,

In cell A1, type: seedword100

Hover your mouse over the lower right corner of cell A1 and your cursor will change to a cross (known as the 'fill handle'). Click your mouse and hold the mousebutton down as you drag downward through cells A2, A3,.. A20, A21.. A2091, A2092 (as far as you want!)

A2 will update to seedword101, A3 will have seedword102, etc.

In reference to your 'Fill Down' remark - no, it's not the same as Fill Down. It is, however, the same as Fill -> Series -> Autofill. You could type seedword100 in cell A1, then select cells A1 through A100 and click Edit -> Fill -> Series -> Autofill to get the same result.

Originally Posted by pjoaquin

Hi toolsavvy,

In cell A1, type: seedword100

Hover your mouse over the lower right corner of cell A1 and your cursor will change to a cross (known as the 'fill handle'). Click your mouse and hold the mousebutton down as you drag downward through cells A2, A3,.. A20, A21.. A2091, A2092 (as far as you want!)

A2 will update to seedword101, A3 will have seedword102, etc.

In reference to your 'Fill Down' remark - no, it's not the same as Fill Down. It is, however, the same as Fill -> Series -> Autofill. You could type seedword100 in cell A1, then select cells A1 through A100 and click Edit -> Fill -> Series -> Autofill to get the same result.

Got it. It works!

However, in between my last post and your reply, I tried it in OpenOffice Calc and got everything to work there using the Fill -> Series in the "edit" menu. Excel 2000 does not have the Fill -> Series in the "edit" menu. You have to do it by dragging like you showed me. The dragging technique would have saved me more time had I checked this thread sooner instead of working too hard. LOL.

Thanks all.