I want to take the original naming in the image below and turn it into the required naming format. This includes substituting "/" with "-" and then adding a leading zero to sequence number at the end of the number.
Using the 1st column, I used a simple Substitute formula to change the "/" to a "-" in the 2nd column. But I can't figure out how to add the leading zero like shown in the 3rd column. And then to make the substitution and leading zero addition work together in a single formula possibly?
Using the 1st column, I used a simple Substitute formula to change the "/" to a "-" in the 2nd column. But I can't figure out how to add the leading zero like shown in the 3rd column. And then to make the substitution and leading zero addition work together in a single formula possibly?