creating a list of letters in a column
 

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

creating a list of letters in a column
 

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

creating a list of letters in a column
 

By the way, if you don't want to start in the first row, then change the
number that is subtracted from the Row() function to the row you want to
start in. For example, if you want to start in the fourth row, use this
instead:

=IF(INT((ROW()-4)/26)0,CHAR(INT((ROW()-4)/26)+64),"") & CHAR(MOD(ROW()-4,
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

creating a list of letters in a column
 

This is a bit simpler:

=MID(ADDRESS(1,ROW(),4,TRUE,""),2,1+(ROW()26))

if you don't start in A1, change

Row()

to something like Row()-4. This would be if the formula starts in A5 as an
example.

--
Regards,
Tom Ogilvy


"Lila" wrote in message
...
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

creating a list of letters in a column
 

Wonderful! Thanks!

Lila
"Tom Ogilvy" wrote in message
...
This is a bit simpler:

=MID(ADDRESS(1,ROW(),4,TRUE,""),2,1+(ROW()26))

if you don't start in A1, change

Row()

to something like Row()-4. This would be if the formula starts in A5 as
an
example.

--
Regards,
Tom Ogilvy