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
|