Hi,

Try this in B1

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

Mike

"yclhk" wrote:

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