Format australian and mobile number as E164 (International format)

I need to clean and format Australian mobile numbers in in E164 format, I tried to use Regex but couldn’t get it to work, finding it really frustrating, can you please help with this specific problem I would be grateful.

Hey @Morgan_Drew :wave:

Happy to help! We’re often able to avoid using Regex by using other steps such as Find and Replace and Extract Text from Columns. Can you please provide some examples of the original starting format and your desired end format?