Excel formula Plus 1 from cell above after second dash

[SteelDoor]

Hi Expert,



I have the below inputs on excel and currently have to manually change the numbers after the second dash.

is there a formula i can use to drag down to only increase the number after the second dash to read



01

02

03

04



and so on?

06-B-01-A

06-B-02-A

06-B-03-A

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Redirecting

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[SteelDoor]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Redirecting

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

thanks for the heads up RoryA. posted on Redirecting also.

 

[SteelDoor]

Resolved this with the help of HansV MVP

Redirecting