Concluído

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

+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 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

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.

Habilidades: Excel, Visual Basic, Visual Basic para Apps, Processamento de dados

Sobre o Cliente:
( 2 comentários ) Hyderabad, India

ID do Projeto: #34488046

Concedido a:

NANSAMEERA86

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 Mais

₹2500 INR / hora
(13 Comentários)
3.2

14 freelancers estão ofertando em média ₹462/hora nesse trabalho

MamukaB

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 Mais

₹290 INR / hora
(49 Comentários)
4.9
yesubabu10203

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 / hora
(36 Comentários)
4.8
NaderShehata

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 Mais

₹250 INR / hora
(4 Comentários)
3.6
vnegi2016

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 / hora
(25 Comentários)
3.1
navdeep033

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 Mais

₹250 INR / hora
(0 Comentários)
0.0
shivharem000

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 / hora
(0 Comentários)
0.0
mehboobakram737

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 Mais

₹200 INR / hora
(0 Comentários)
0.0
bk89449702

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 Mais

₹750 INR / hora
(0 Comentários)
0.0
payalmandhalkar

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 / hora
(0 Comentários)
0.0
alaakassem1996

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 Mais

₹250 INR / hora
(0 Comentários)
0.0