Adding Alphabet

[yclhk]

Is it possible to set a formula to set :
in A1 : 101A
set formula in B1 to get the value 101B
if change the value in A1 to 101B
set formula in B1 to get the value 101C

 

[David Biddulph]

=LEFT(A1,LEN(A1)-1)&CHAR(CODE(RIGHT(A1))+1)
but you haven't said what you want to do when you get to 101Z

 

[Mike H]

Hi,

Try this in B1

=101&CHAR(CODE(RIGHT(A1,1))+1)

Mike