Hi all, I was wondering if what I am tasked with is possible. I have thousands and thousands of codes, that I need to convert into a more usable format. I am wondering if there is a formula or way of converting these codes.

For instance, each code needs to look like this: XXXX-XXXXX (4 digits, a dash, 5 digits).

A few examples of how they are currently formatted:

556-32840
2568-00630
3229- 1360


And how they should look:

556-32840 - Should be 0556-32840 (added a "0" to the first string)
2568-00630 - Should be 2568-00630 (no change)
3229- 1360 - Should be 3229-01360 (added a "0" to the second string)

In ALL cases, any space should equal a "0".

Anyone know if this is possible? Thanks so much !

EDIT: ALSO, in all cases, the spaces will appear at either the front of the first or second string.