Auto Fill Number & Letter

[Chapis]

I need someone to look at my formula and tell me what I'm doing wrong. I would like to auto-fill down a number & letter but only change the letter

example:
1A
1B
1C
& so on.

I originally started with =LEFT(A1,6)&CHAR(CODE(RIGHT(A1,1))+1) but it returns 1AB
for the life of me, I can not figure out how to correct the formula to not repeat the A

Thanks in advance for your help

 

[RobP]

try this:

=LEFT(A1,1)&CHAR(CODE(RIGHT(A2,1))+1)

 

[Chapis]

try this:

=LEFT(A1,1)&CHAR(CODE(RIGHT(A2,1))+1)

THANK YOU!

I ended up using =LEFT(A1,1)&CHAR(CODE(RIGHT(A1,1))+1) and realized this 6 [ =LEFT(A1,6)&CHAR(CODE(RIGHT(A1,1))+1) ] in my original formula must have been my problem.

It's the simple things that trip me up. I would not have figured it out on my own, I appreciate your help!

 

[RobP]

you're welcome, thanks for the feedback.

Rob