Proper Phone Numbers Based on Country Code

Hi,

I looking for excel formula which converts improper phone numbers into proper way based on country & Country code as shown in below or in attachment.

Country CountryCode PhoneNumber Result (I expect)
Algeria +213 +21321240686 213-21240686
Angola +244 +244222311561 244-222311561
Argentina +54 +1152736000 54-1152736000
Australia +61 +61294286555 61-294286555
Austria +43 +43073290610 43-073290610
Japan +81 +81426466724 81-426466724
Bahrain +973 +17228446 973-17228446
Belgium +32 +3222024111 32-22024111
Brazil +55 +555134807200 55-5134807200
Romania +40 +4032537222 40-32537222


Note: If country code is doesn't exist it should add automatically matching with country.

Can anyone please me with this?

Thanks & Regards,
Mohan

Hi Speshul,

I doesn't work properly, please check Argentina & Bahrain country it doesn't include country code at beginning. The result I expect if phone number contains country code it should divide with "-" and if phone number doesn't include country code at beginning of phone number then it has to include country code.

Hi Alkey,

Thanks for reply but It doesn't work properly, please check Argentina & Bahrain country it doesn't include country code at beginning. The result I expect if phone number contains country code it should divide with "-" and if phone number doesn't include country code at beginning then it has to include country code.

It works Mr.Alkey, Thanks a lot!!!