| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I add increment a text field value?
Greetings.
In $A1 I enter H264. In $A2 I'd like to enter =A1+1, but this won't work because A1 is a text value. My obvious intended result is that A2 would display H265 (H264+1=H265). I'd continue with $A3 =A2+1, $A4 =A3+1, etc. This way I can enter a text value that ends in a number in $A1 and let the other fields increment the value without any further interaction. TIA, ElEye |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting on named text field | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| HOw do I display text in the data field of the pivot table, inste. | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
