Need formula to increase Alpha character to next letter
 

I am looking for a formula that will increase by one letter the alpha
designation in a column. ex. A2 would be the letter 'A', B2 which would show
the next letter of the alphabet should be 'B'. I know how to increase a
number, ex. =(A2+1), how do I do the alphabet?

Answer: Need formula to increase Alpha character to next letter
 

Sure, I can help you with that! You can use the

Code:

---

CHAR

---

and

Code:

---

CODE

---

functions in Excel to increase the alpha character to the next letter. Here's how:

1. In the cell where you want to display the next letter, enter the following formula:
   Code:

   ---

   =CHAR(CODE(A2)+1)

   ---

2. In this formula,
   Code:

   ---

   A2

   ---

   is the cell that contains the current letter. The
   Code:

   ---

   CODE

   ---

   function returns the ASCII code for the letter in cell A2, and the
   Code:

   ---

   +1

   ---

   increases the code by one.
3. The
   Code:

   ---

   CHAR

   ---

   function then converts the new ASCII code back into a letter.
4. Copy the formula down the column to apply it to all the cells.

That's it! Now, each cell in the column will display the next letter in the alphabet. Let me know if you have any questions or if there's anything else I can help you with.

Need formula to increase Alpha character to next letter
 

Why do you need to repeat post?

Posted the response below in your earlier thread:
If A2 contains: A,
then this in say B2: =CHAR(CODE(A2)+1)
will return the next letter: B

voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"pwinters" wrote:
I am looking for a formula that will increase by one letter the alpha
designation in a column. ex. A2 would be the letter 'A', B2 which would show
the next letter of the alphabet should be 'B'. I know how to increase a
number, ex. =(A2+1), how do I do the alphabet?

Need formula to increase Alpha character to next letter
 

=CHAR(CODE(A2)+1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"pwinters" wrote in message
...
I am looking for a formula that will increase by one letter the alpha
designation in a column. ex. A2 would be the letter 'A', B2 which would
show
the next letter of the alphabet should be 'B'. I know how to increase a
number, ex. =(A2+1), how do I do the alphabet?

This works fine for up to Z then if want AA, AB, AC... what should be done.

I found this on another site:

"if you put A1 inside row(), then you can put the formula in
starting in any row and drag fill it down:

=CHAR((ROW(A1)-1)/26+65)&CHAR(MOD(ROW(A1)-1,26)+65)

(my own version of the formula)

as an example.


Regards,
Tom Ogilvy"

For me, this worked for AA, then for AB, I had to change the "A1"s to "A2"s, then I copied and Pasted-Special for the rest of the column, and it worked.

From: http://www.pcreview.co.uk/threads/ho...to-zz.1010611/