Add or incerase a letter at the end of a cell

[JT3101]

Hi all,
Firstly I'm a complete novice when it comes to Excel so apologies if this is the most basic of the basic. I have a column of cells each containing a short piece of text (Format is A#A#####) and I would like to add an A to the end of each of these cells. However some already have a letter at the end such as an A or B. For these I would like to increase it to the next letter ie A to B, B to C and so on.
Is there any way to do this?
Thanks for any help offered.

 

[Joe4]

Welcome to the Board!

Assuming that all the letters at the end are upper case, and you would never need to go past "Z", try this formula for an entry in cell A1:

=IF(AND(CODE(RIGHT(A1,1))>=65,CODE(RIGHT(A1,1))<=90),LEFT(A1,LEN(A1)-1)&CHAR(CODE(RIGHT(A1,1))+1),A1&"A")

 

[JT3101]

Hi again,
I've tried that formula but I just get the following error message whenever I enter it.

 

[Joe4]

It sounds like you are putting the formula in the same cell that you are trying to call.
What cell are you putting the formula in, and what cell are you referencing with the formula?

 

[JT3101]

Reading your message must have kick started something in my brain and I figured it out. It works perfectly. Thanks for your help.

 

[Joe4]

You are welcome.
Glad I was able to help!