Numerical number sequence, but keep the ending number?

[go77377]

Can someone help me out with how to create a number sequence with a formula?
For example this number "TM2500-20", is in cell B1, What I am trying to do is have cell B2 insert "TM2501-20", B3 insert "TM2502-20" down each row. I need the "20" which represents the year but the numbers before the "20" change in numerical order, does that make sense?

 

[Fluff]

How about
="TM"&mid(b1,3,4)+1 &"-20"

 

[mikerickson]

Try

=TEXT(ROW(A2500),"""TM""0000""-20""")

 

[go77377]

Fluff, I tried your formula and it wouldn't work.... Mike, your's worked like a charm..... Thank you both for the effort!!!!

 

[Rick Rothstein]

Try

=TEXT(ROW(A2500),"""TM""0000""-20""")

You could save a few characters by doing that TEXT function call this way...

=TEXT(ROW(A2500),"T\M0000-2\0")