I would like to know if there is a formula to make a numbering format standardised. I have a work sheet, with a column that contains data similar to below:
45-02-001
45-02-002
45/02/003
45-02-004
45/02/005
45-02-006
Some of the fields separate the numbers with "-" and others with "/" (due to...