VBA Script

I get data always from different people and it is in this format: 91 80 40931584(R) 9980099607(M) - 999999999999999(M) - this is not valid. **Remove & shift data above** 91 - 9886033006 91-080-9886033006 0877 3120132 91-0877-2241056 09860021507291-- remove as this is beyond 10 digit. +919380519217 +91-44-2447 5200 +919380519217 +91-44-2447 5200 In the case of landline nos., 91 is country code and 80 is city code (which can be 2-4 digits) and after that 7 digit (40931584) is telephone no. If any occurrence VBA finds, then it should produce result like: 08040931584 removing all 91s. In the case of mobile nos., mobiles will start from 7/8/9, e.g. 9980099607 and they will be strictly 10 digits. AI should remove all +91s and sometimes 91 (no plus). This creates so much confusion. I want...