Changing from (+44)7000-000000 to 0044 7000 000000

[Tommaso83]

Dear Community

What formula should I use to change a Mobile number from (+44)7000-000000 to 0044 7000 000000?

Thanks

[OllieClarke · Accepted solution]

Hi @Tommaso83 try this:

Replace(Replace(ReplaceChar([Field],')-',' '),'+','00'),'(','')

Hope that helps,

Ollie

[Tommaso83]

Amazing!!!

Thanks for the super-quick help 🙂

[OllieClarke]

@Tommaso83 no worries. If my answer solved your problem, would you mind marking it as a solution so other people with the same problem can find it later?

Thanks,

Ollie

[Tommaso83]

Done @OllieClarke