I'm trying to get a Formula. a little example: instead of 0172/3456789 or (0123)-456789, i would like all phone numbers to be just the numbers +49172345678 / +49123456789. What formula should I use for this ?

Question

Abhi Tripathi · Answer

Hi Tom,

Here is the formula to remove ( ) from the formula, thanks to Steve Mo, you can + in the starting

SUBSTITUTE(

SUBSTITUTE(Phone, "(", ""), ")", ""), " ", ""), "-", "")

Here is more info

https://success.salesforce.com/answers?id=90630000000h0fEAAQ

I'm trying to get a Formula. a little example: instead of 0172/3456789 or (0123)-456789, i would like all phone numbers to be just the numbers +49172345678 / +49123456789. What formula should I use for this ?

Data Management

Aprendizagem relacionada

Mais ajuda