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

Dear Community

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

Thanks

Reporting

Accepted answers

Hi @Tommaso83 try this:

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

Hope that helps,

Ollie

Hi @Tommaso83 try this:

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

Hope that helps,

Ollie

Amazing!!!

Thanks for the super-quick help 🙂