=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
--
David Biddulph

"yclhk" wrote in message
...
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