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 |
#2
|
|||
|
|||
Hi
One way, in cell A1 enter ="H"&Row()+263 then as you copy down, ROW() will increment from 1, 2,3 etc. increasing your value as appropriate. Regards Roger Govier ElEye wrote: 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 |
#3
|
|||
|
|||
Hello ElEye.
Not real certain whether your requirement is to fill a series of cells immediately or dynamically. If immediately, the FillSeries feature of Excel is very efficient. Enter H264 in cell A1, H265 in cell A2 then drag the fill handle that appears in the lower right corner of A2 down through cells A3, A4, etc. If this does not meet your requirement a visual basic module could be developed to meet your need. Good luck. "ElEye" wrote: 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 |
#4
|
|||
|
|||
try
="H"&264+row(A1) "ElEye" wrote: 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 |
#5
|
|||
|
|||
You could use acustom format in A1 like
"H"000 then type 264 in A1 in in A2 use =A1+1 and copy down or =LEFT($A$1)&RIGHT(A1,3)+1 in A2 and copy down I'd suggest the first method Regards, Peo Sjoblom "ElEye" wrote in message ... 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 |
Reply |
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) |