Insert hyphens between a string
Hi. I have a column with numbers typed as
3000100123
I need to add zero before the first character, insert a hyphen after the first char, and insert another hyphen after the fifth, like
03-0001-00123
What I did to get the desired result was to create 5 helper columns parsing the numbers then joining them all. At first I tried creating a formula but gave up. How should I do it with a formula?
Thank you.
|