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

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

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

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

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