Forum Discussion
Excel formula with a number that contains a dash ex. 2030-0051
I am trying to create a formula to have consecutive number sequence by adding 1 to the cell, but since the number itself contains a dash (or in Excel's language minus) it is giving me an error. I use...
If build the series that's definitely as Riny_van_Eekelen suggested. If for something else, variant could be
=LEFT( A1, 4 ) & "-" & TEXT( RIGHT( A1,4 )+1,"0000")