1 reply to this topic

[ttmail]

A little background to my question - I live in the UK so half of my contacts and therefore telephone numbers use the STD code for the UK which could be 0207/0208/0161/ etc.

All my local codes start with just one "0"

Whereas the International codes have two zeros "00".

So is their a script that would insert +248 into the field then the rest of the number instead of the "00" and when it comes to the UK telephone numbers just being one "0" then leave the field as I have inputted. Example 01604 123 4567

Hope someone can help as I cannot work out how to do this.

Sorry if I haven't explained myself well.

Thanks

[comment]

Try =

Substitute ( "§" & PhoneNumber ; [ "§00" ; "+248" ] ; [ "§0" ; "0" ] )