Try:

=IF(INT((ROW()-1)/26)0,CHAR(INT((ROW()-1)/26)+64),"") & CHAR(MOD(ROW()-1,
26)+65)

Regards,
Greg

"Lila" wrote:

I need to create a column that letters the row. For example, A1 is A, A2 is
B. There are about 150 rows, so it needs to loop through AB, AC etc.

I would like to find a formula to do this so that if I add a row, it
recalculates the entire column.

Thanks,

--
Lila