Help with generating sequence of numbers

[riteon]

I would like to use Excel to generate a sequence of numbers 5 digits in length from a set of letters in a column.

e.g.
a
b
c
d
e
f
g
h
j
k
m
n
p
q
r
s
t
u
v
w
x
y
z
1
2
3
4
5
6
7
8
9


So let's say we have columns A to E filled with the same data as above.

I would like the first number in column F (F1) be generated from the first row of each of the numbers.
Then the second number in column F (F2) to use the same first four numbers, then use the second one down in E.
This is to be continued until all numbers have been exhausted in column E, then the second one down in column D is used.

So I get

aaaaa
aaaab
aaaac
aaaad
aaaae

etc.
etc.
etc.

then the final number would be

99999

Is this possible in Excel?

Thanks

EDIT: Managed to find a tool here http:// sequence-generator .com that does the bizz.

 

[GlennUK]

And what would you do with these 60466176 rows of output?

 

[riteon]

And what would you do with these 60466176 rows of output?

Hi glen, we actually only needed 1m of these for sequential numbers for unique identification of documents within a business. These are copied into a database and are searchable as a ref no.

Thx