Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ShaTShaT 

Convert a Phone number to Correct Phone Format

Hi,

I have a phone no- +1 2132007307  which i need to convert into (213) 200-7307 this format. 
How can i do this with formula field.

Thanks
ShaT
Best Answer chosen by ShaT
Himanshu ParasharHimanshu Parashar
Hey Sha,

Try following formual

  
IF(Country_Code__c = 1, MID( Phone ,2, 3) &'-'& MID(Phone,7,3)&'-' & MID(Phone,11,4), Phone)