#1




Formula to add +1 to a sequence
What formula would work to make the change from RE249869000xxx00xxxx0001 to RE249869000xxx01xxxx0001 and the next RE249869000xxx02xxxx0001 and all the way to RE249869000xxx99xxxx0001 Last edited by Benali; 05032020 at 01:30 PM. 
#2




For example:
="RE249869000xxx" & TEXT(ROW()1,"00")& "xxxx0001" However, this isn't going to produce RE249869000xxx99xxxx0001 on row 12. The logic for that result escapes me.
__________________
Cheers, Paul Edstein [Fmr MS MVP  Word] 
#3




That worked perfectly
now, can we make the 0001 go to 9999 in the same formula? 
#4




Really, that's a trivial change to the formula. How about studying it instead of expecting to be spoonfed. Otherwise, you'll learn nothing.
__________________
Cheers, Paul Edstein [Fmr MS MVP  Word] 
#5




I’ll try. Thanks

#6




If D is the column, In the column where you would like the new values output enter the formula =a1+$D$1 and copy down the column. Now whatever value you put in D1 will be added to the values in column A. if you want to subtract, just enter 1 into D1.

#7




CJustin: I have to wonder whether you bothered to read the question … or the answer in post #2.
__________________
Cheers, Paul Edstein [Fmr MS MVP  Word] 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Format in a formula month and numbers  Marcia  Excel  10  02282019 05:55 AM 
How make IF Formula return a numbers joined with a letter  Strogg  Word  11  01072019 03:13 PM 
Create a sequence of numbers using a formula  14spar15  Excel Programming  9  03192018 01:15 AM 
Link to automated table and formula numbers  Jacky837  Word  1  07252016 10:45 AM 
Find & Replace formula for numbers?  Griff  Word  4  04182011 02:47 AM 