add a letter to the end of a number

[b19upj]

Hi,

I have to insert some rows to my existing spreadsheet.
The rows are currently numbered in column A from 1 until 3000.
I am adding rows to add a level of detail to some of the items numbered above. Because of this, I want the rows I add to use the number from the row above but add 'a' to the first, 'b' to the second, 'c' to the third, and so on.
Is there a formula i can use in column A to use the number and add a letter (going up from a-z) automatically instead of me manually dragging the column A number and writing a,b,c,d, etc?

TIA

 

[ChrisBM]

=IF(ISNUMBER(VALUE(LEFT(INDIRECT("A" &ROW()-1),1))), "a" & INDIRECT("A" &ROW()-1), CHAR(CODE(LEFT(INDIRECT("A" &ROW()-1),1))+1) & RIGHT(INDIRECT("A" &ROW()-1), LEN(INDIRECT("A" &ROW()-1))-1))

Not the tidiest but it will work.

 

[AbuTurab]

Hi,

Try the below, too

Place it in cell A1; then copy it down to A3000

=SUBSTITUTE(ADDRESS(1,ROW(),4),"1","") & ROW()

 

[XOR LX]

Hi.

=CEILING(ROWS($1:1)/26,1)&CHAR(97+MOD(ROWS($1:1)-1,26))

Copy down as required.

Regards