I have some imported data that needs to be reformatted. It is phone numbers in Australian format. The current data is 712345678. The result should be (07) 1234 5678.
I can easily morph the data to first remove the first digit leaving 12345678. I can also add a prefix (07) (with a space after the parentheses)that now gives me (07) 12345678.
I can’t find how to put a space between the 4 and the 5. I am sure this is easy but it eludes me at the moment. Please point me in the right direction.