ALPHABETICAL FORMULA

[pwinters]

I need a formula that will increase an alpha character by one. ex. Column
heading is Revision and the column contains A. I want to add a column with a
formula that will result B. similar to =(A2+1) for numberic.

 

[Max]

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