Auto Increment a part of String in excel

[akashk86]

I have this number string in text form.

ex.
first value - +12122000122
last value - +12122999922

I want to to use the auto increment to get the new string and upto the last string value as mentioned above. so that the last two and initial five digits(including + ) do not change. can you please help me find the correct formula.

 

[RudiS]

Try this:

Excel 2012
	A	B	C
1	1	+12122000122
2	2	+12122000222
3	3	+12122000322
4	4	+12122000422
5	5	+12122000522
6	6	+12122000622
7	7	+12122000722
8	8	+12122000822
9	9	+12122000922
10	10	+12122001022
11	11	+12122001122
12	12	+12122001222
13	13	+12122001322
14	14	+12122001422
15	15	+12122001522
16	16	+12122001622
17	17	+12122001722
18	18	+12122001822
19	19	+12122001922
20	20	+12122002022
21	21	+12122002122
22	9999	+12122999922
23
Sheet4

Cell Formulas
Range	Formula
B1	="+12122"&TEXT(A1,"0000")&"22"

 

[gaz_chops]

Similar, without the helper column.

="+12122"&TEXT(ROW(A1),"0000")&"22"

 

[ukmikeb]

Or :-

="+1" &2122000022+(10^2*ROW(A1))

hth