Hello,

I have a difficult scenario which I cannot wrap my head around, I hope there's an Excel PRO here who can help me!

It has to do with editing and formatting telephone numbers and country codes.

Here it is:


EMBED:
C2 = IF A2=France AND IF B2 has 9 digits AND IF B2 starts with 6, THEN add "33" to the beginning of B2, otherwise copy as is
C2 = IF A2=Belgium AND IF B2 has 9 digits AND IF B2 starts with 47 OR 48 OR 49, THEN add "32" to the beginning of B2, otherwise copy as is
C2 = IF A2=United Kingdom AND IF B2 has 10 digits AND IF B2 starts with 71 OR 73 OR 74 OR 75 OR 77 OR 78 OR 79, THEN add "44" to the beginning of B2, otherwise copy as is

etc... there are a lot of countries with different conditions

HOW DO I EMBED SO MANY CONDITIONS ???

I would really really appreciate any help !

Thanks to all

Eli