VBA Script

Job Description:

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


+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 some VBA Script which works with artificial intelligence (I mean some logic) and understands all mobile numbers and landline numbers and clears them and distributes them in new columns if need be. If its only 1 number leave it there only.

Final result I am expecting should be:

08040931584 9980099607

9886033006 9886033006 (91-080-removed because it is a mobile and doesnt require city and country code)

08773120132 08772241056

9380519217 04424475200



The subscriber phone numbers are 6, 7 or 8-digit long depending upon the length of the STD code. STD codes are either 4, 3 or 2 digits.

When the area code is 2-digit, the phone number is 8-digit (2+8)

When the area code is 3-digit, the phone number is 7-digit (3+7)

When the area code is 4-digit, the phone number is 6-digit (4+6)


I already have code. modification is required. Please check attached file.

Навыки: Excel, Visual Basic, Visual Basic для приложений, Обработка данных

О клиенте:
( 2 отзыв(-а, -ов) ) Hyderabad, India

ID проекта: #34488046



Hi Sir, This can be done with good quality. I am a professional Excel VBA developer with more than 10 years of working experience in developing customized systems, reports and dashboards using MS Excel formulas, pivot Больше

₹2500 INR / час
(13 отзывов(-а))

14 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹462/час


hello I can do this project within day, using Excel VBA, but need some information regarding source file type and also all possible cases of Phone numbers I have 15+ year experience of Excel, Excel VBA, Python and 100 Больше

₹290 INR / час
(49 отзывов(-а))

Hi there myself yesu I am a vba/python developer I can do this you can contact me on this for further discussion thanks

₹250 INR / час
(36 отзывов(-а))

Hi, it seems that you want to create a VBA macro to format some telephone and mobile numbers of the data you receive I checked the code you uploaded and it needs some work and modifications I am an Excel expert and Больше

₹250 INR / час
(4 отзывов(-а))

HI, I am vikram, read your project description. I can create the vba script as per requirement. Please message me to discuss more. Regards, Vikram

₹200 INR / час
(25 отзывов(-а))

Hi, After going through the provided details in the job description, I believe that my candidature for this job is affirmatively strong. I am Experienced in Data Entry and have more than 5 years of experience su Больше

₹250 INR / час
(0 отзывов(-а))

I am Intrusted to work for you I understand your need clearly what you want. i am confident that i can do this work.

₹300 INR / час
(0 отзывов(-а))

I use a 5 group activity to persistently convey occupations on-time and meet or surpass assumptions for each request. Our group is exceptionally conversational in English, and we have serious areas of strength for an o Больше

₹200 INR / час
(0 отзывов(-а))

Hello Sir, I have already uploaded 2000 products in shopify for a client i have proven experience i will help you enter products manually in shopify and meet your daily target i am open to training as well can you mess Больше

₹750 INR / час
(0 отзывов(-а))

I have 4 years of experience in vba macro i worked on 20 lacs data in excel i develope lots of projects in vba

₹400 INR / час
(0 отзывов(-а))

As a coding enthusiast, I spent the last year in a position (at the National Bank of Canada) that required me to improve and develop new codes. I take pleasure in increasing efficiency in less-efficient codes as well a Больше

₹250 INR / час
(0 отзывов(-а))