Hi, Excelforum People.

Here's my question.

I want to create a list from a "seed" word that consists of a word followed by a number (ex: seedword100).

What I want to do is to be able to create a list in Excel using that seed word and then have excel produce a bunch of replications of that seed word by incrementing the number part of the seed word by 1 for every replication.

So, for example, if cell A1 = "seedword100", I want Excel to replicate it up to "seedword199" like this...

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

and so on until the last cell = seedword199 (or whatever number I want it so stop at).

Anyone know how I would do this?

I hope I was clear. If not, please tell me what's not clear and I will try to explain better.

Thanks,
Dan