I have strings in Excel like AA
or XA
.
I need to increment them like this:
For AA
in cell A1, it will be AB
in cell B1, AC
in cell B2 and so on.
For XA
in cell A1, it will be XB
in cell B1, XC
in cell B2 and so on.
I tried the popular code =CHAR(CODE(A1)+1)
but it does not work after Z.
Any hints are welcome.
Does not work after Z
? Do you mean afterAZ
orZZ
File > Options > Formulas >R1C1 reference style
INDIRECT
formula for example, then @DirkHorsten's comment might be worth noting.