Forum Discussion
rockyb855
Sep 18, 2023Copper Contributor
row values a -> z aa ->zz
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...
- rockyb855Copper Contributorthanks