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.