On more, put this in A1 and drag down:
=CHAR(INT((ROW(A1)-1)/26)+97)&CHAR(MOD(ROW(A1)-1,26)+97)

If you really mean upper case, change the 97's to 65's:
=CHAR(INT((ROW(A1)-1)/26)+65)&CHAR(MOD(ROW(A1)-1,26)+65)



"JethroUK©" wrote:

i need to generate these letters

aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column

What's best/easiest way?

--

Dave Peterson