+1 Text and number incement

[max8719]

Help please,

Problem is in D19 I could have "week 1" up to "week 52" and I would like E19 to plus 1 for example if D19 was "week 1" E19 would be "week 2" or if D19 was "week 40" E19 would be "week 41".

Any solutions guys??

 

[Rick Rothstein]

Problem is in D19 I could have "week 1" up to "week 52" and I would like E19 to plus 1 for example if D19 was "week 1" E19 would be "week 2" or if D19 was "week 40" E19 would be "week 41".

Will there always be a space between the text and the number? If so, give this formula a try...

=LEFT(D19,FIND(" ",D19))&(1+MID(D19,FIND(" ",D19),99))

 

[max8719]

Perfect..... You are an absolute gem! Thank You