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?
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 |