SOLVED

row values a -> z aa ->zz

Copper Contributor

I can use a formula like this, with I1 = A

=CHAR(CODE(I1) + 1)

And it will produce A to Z.

But is there some way to have cell values automatically generate down like column letters?

a -> z then aa -> zz etc...

2 Replies
best response confirmed by rockyb855 (Copper Contributor)
Solution

@rockyb855 

In I1:

=TEXTBEFORE(ADDRESS(1,ROW(),2),"$")

Fill down.

thanks
1 best response

Accepted Solutions
best response confirmed by rockyb855 (Copper Contributor)
Solution

@rockyb855 

In I1:

=TEXTBEFORE(ADDRESS(1,ROW(),2),"$")

Fill down.

View solution in original post