Hi,
I understand that you need it urgently. I plan to use VBA codes in Excel (Customized Macros) to achieve your goal. But then it is required that the name of the country is mentioned in each record, so that the script can look up for the country, and then apply the appropriate format on the telephone numbers.
For emails, all the script can do is look for the @ character in the text, and check that it has at least one dot (.) after the @ sign. Predefined domain extensions can be checked for as well (like, .net, .org, .edu or .com ) followed by country abbreviations .au, .de etc ...
So if you think that based on your data, writing a macro should be feasible you can send me a message for further details if needed. Writing the script shall not take me more than an hour or a two. So hopefully I can deliver you the work in a day.
Thank you & best regards
Raad