Adding Alphabet
 

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

Adding Alphabet
 

=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

Adding Alphabet
 

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