Need formula to increase Alpha character to next letter

[pwinters]

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?

 

[Max]

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

 

[Niek Otten]

=CHAR(CODE(A2)+1)