tag:blogger.com,1999:blog-5187067.post5241730001466030349..comments2023-07-25T04:14:05.366-05:00Comments on Chris Lehr's Microsoft blog: Normalizing Phone Numbers to E.164 format in ExcelChris Lehrhttp://www.blogger.com/profile/12048658420556993119noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5187067.post-65477830481792467582013-10-30T16:26:24.092-05:002013-10-30T16:26:24.092-05:00This was incredibly helpful! Thank you!This was incredibly helpful! Thank you!Tabithahttps://www.blogger.com/profile/14547655752168111623noreply@blogger.comtag:blogger.com,1999:blog-5187067.post-4555760888058201902013-10-30T16:26:00.528-05:002013-10-30T16:26:00.528-05:00This was incredibly helpful! Thank you so much! This was incredibly helpful! Thank you so much! Tabithahttps://www.blogger.com/profile/14547655752168111623noreply@blogger.comtag:blogger.com,1999:blog-5187067.post-36909220266562515462013-02-15T22:16:19.103-06:002013-02-15T22:16:19.103-06:00Thanks for that very helpful. I made a couple of m...Thanks for that very helpful. I made a couple of minor changes <br />- Australian country code<br />- Removal of leading zeros (Australian phone numbers have leading zeros when dialling locally)<br /><br />=IF(D2="","",CONCATENATE("+61",IF(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2,"(",""),")","")Anonymoushttps://www.blogger.com/profile/10816666709655577489noreply@blogger.com