Forum Discussion
chris7749
Jul 02, 2023Copper Contributor
Format change - How to place "-" between numbers
I have a list of phone numbers that are not in a consistent format, and I want them all to have the same format, which is with a hyphen "-" between the numbers. It should be shown as the following ex...
- Jul 02, 2023
peiyezhu
Jul 02, 2023Bronze Contributor
=IF(LEN(B2)=11,WEBSERVICE("http://e.anyoupin.cn/eh3/?regreplace~(\d{3})(\d{4})(\d{4})~\1-\2-\3~" & B2),B2)