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.
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?