I have a list of 40000 entries about people, there is a field for the phone number, the problem is that the numbers are not in unified format, also sometimes more than one number is inserted in the same field. the task is to add enough columns so that each cell contains only one phone, also each phone must be put in the format:
country code area code number
example: if country is lebanon then code is 961
area mobile theb code is 03
number is 558160
in the cell it should display 9613558160 note that if area starts with 0 then it is excluded, otherwise its not, in the example above if area was 76, then the number will be 96176558160
61 pekerja bebas membida secara purata $34 untuk pekerjaan ini
I can write a simple macro to fix this. Lets start. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implementation.
Hello sir,we have 8 member team and we can start the work right now just check my review u can see and u never disappointed with my work quality,delivery and price. Awaiting your [login to view URL]
Hello! I am an excel expert. I completed many simillar projects in the past as you can see on my profile. You will not be dissapointed. I have a rehire rate of 31%. Thank you!
Hi, I will work as per your direction. I ensure you 100% accuracy of my work. Please see my profile reviews to check my working reputation. I am waiting for your response to start working. Thanks
Hello Sir, I would like to work with your project. Before, I am ready to show sample. I am waiting for your message. I will provide High Quality Work. Cheers!
Sir, I am willing to do your project and ready to start work. I will provide you a good result with accuracy. My aim is to satisfy my client by my work. Please response. Thanks
Hello, your project interested me, I have a good experience in this kind of work, can offer you high quality work, perfect service, good price. Contact me to discuss all details.