Forum Discussion

MT_15's avatar
MT_15
Copper Contributor
Dec 07, 2020

Using autofill to change only certain numbers in a string

Hi all,

 

I want to use autofill to increase certain numbers in this string but don't know how. For example, in the strings attached below, I only want to increase the page number, which is in the middle of the string, not the max item per page number, which is at the end of the string. Can someone show me how to do it if it is possible at all? 

excel
office 365

1 Reply

  • MT_15's avatar
    MT_15
    Copper Contributor
    Dec 07, 2020

    MT_15 

     

    I also wish to autofill the date, which is also somewhat in the middle of the string. So from 20/12/1997 to 21/12/1997, 22/12/1997, et. 

Resources