Use this formula in A1, B1, C1, D1:

=CHAR(CODE("A")+MOD(INT((ROW()-1)/(POWER(26,5-COLUMN()))),26))

Use this formula in E1:

=CHAR(CODE("A")+MOD(ROW()-1,26))

Copy down as many times as needed.

In F1, you could use this formula:

=A1&B1&C1&D1&E1

Then, copy down to create a column with the 5-letter combinations in
ascending order.

Just for kicks, I entered these formulae in Excel 2007 in each
available row. The last one - 1,048,576 - has the value of CHRDV.
If you want to take it from there, replace ROW()-1 with ROW()
+1,048,575 in each formula above. This calculation took about 15
minutes.

By comparison, running a similar expression on nearly 700,000 rows in
Access took only a few seconds. I used a combination of ROUND() and
ABS() to achieve the same result as MOD. You might consider that path
rather than messing with Excel.

On Aug 29, 9:24 pm, gretchen
wrote:
Howdy,

I use a database that contains an id field that is a 5 letter "code". So
the first item in the database is AAAAA, the second is AAAAB, the third is
AAAAC and so on until item 26 is AAAAZ. Item 27 is AAABA, then 28 is AAABB,
then 29 AAABC and on and on.

Is there a way for excel to increment all the letters up to ZZZZZ in
seperate cells?

Thanks!