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 used =A1(cell with number) +1. =A1+1. I am sure that I am not the first to have this issue but i could not find anything in help.
2 Replies
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")KirkComeaux A "number" like 2030-0051 is in fact a text. Just drag it down and Excel should increment the text by 1 automatically. No formula needed.
