Create an alphanumeric sequence

Originally Posted by shg

In A1,

= ADDRESS( MOD( INT(COLUMN() - 1) / 26, 10) + 1, INT( (COLUMN() + 259) /260), 4)
& ADDRESS(ROW(), MOD(COLUMN()-1, 26) + 1, 4)

Copy down to A10 and across to column IYZ.

Thanks that worked great! Would you also be able to tell me the formula to make it all into one column? A1A1-Z10Z10 all in column A.

Thanks again.