| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
+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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP WITH ALPHA NUMERIC | Excel Worksheet Functions | |||
| Columns are now numeric, not alpha. how to change back? | Excel Discussion (Misc queries) | |||
| Search string for alpha or numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
| Alpha & Numeric Counts in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
