View Single Post
  #1   Report Post  
Caroline
 
Posts: n/a
Default +1, Alpha *and* Numeric

Cell 1: A12345
Cell 2: B23456

All cells are in the same column (column 1). The formula goes like +1+1+1+1,
but I don't know how to make Excel change the alpha to the next letter. Excel
also goes a little crazy when it comes to going from 9 to 10 - it goes from 9
back to 0.

How do I create a formula which will cause the next cell to read: "C34567",
which will also work for making the 9 go to 10, and not 0?

Also, I am looking to NOT use Visual Basic to solve this problem - only
Excel formulas, nested or not.