Excel formula with a number that contains a dash ex. 2030-0051

%3CLINGO-SUB%20id%3D%22lingo-sub-2874392%22%20slang%3D%22en-US%22%3EExcel%20formula%20with%20a%20number%20that%20contains%20a%20dash%20ex.%202030-0051%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2874392%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20to%20have%20consecutive%20number%20sequence%20by%20adding%201%20to%20the%20cell%2C%20but%20since%20the%20number%20itself%20contains%20a%20dash%20(or%20in%20Excel's%20language%20minus)%20it%20is%20giving%20me%20an%20error.%20I%20used%20%3DA1(cell%20with%20number)%20%2B1.%20%3DA1%2B1.%20I%20am%20sure%20that%20I%20am%20not%20the%20first%20to%20have%20this%20issue%20but%20i%20could%20not%20find%20anything%20in%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2874392%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2874404%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20with%20a%20number%20that%20contains%20a%20dash%20ex.%202030-0051%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2874404%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1193240%22%20target%3D%22_blank%22%3E%40KirkComeaux%3C%2FA%3E%26nbsp%3BA%20%22number%22%20like%202030-0051%20is%20in%20fact%20a%20text.%20Just%20drag%20it%20down%20and%20Excel%20should%20increment%20the%20text%20by%201%20automatically.%20No%20formula%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2875441%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20with%20a%20number%20that%20contains%20a%20dash%20ex.%202030-0051%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2875441%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1193240%22%20target%3D%22_blank%22%3E%40KirkComeaux%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20build%20the%20series%20that's%20definitely%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bsuggested.%20If%20for%20something%20else%2C%20variant%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DLEFT(%20A1%2C%204%20)%20%26amp%3B%20%22-%22%20%26amp%3B%20TEXT(%20RIGHT(%20A1%2C4%20)%2B1%2C%220000%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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.

@KirkComeaux 

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")