function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Convert a Phone number to Correct Phone Format


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.

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)