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?
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?