I have tens of Egyptian Mobile Phone Directory in Excel sheets
I need someone to do the following :
apply some formulas to make:
"Excel File has a Column that Full of Mobiles Numbers with different entries,
Variety between 9 / 10 / 11 / 12 / 13 digits
some starts with country code, some with digit 0 , some without & so on
I need help to do the following:
Problem Result needed
201223104516 to be 01223104516
Start with 2 ( cell contains any No of digits ) Delet the 2 & keep the rest
021223104516 to be 1223104516
Start with 02 ( cell contains any No of digits ) Delet the 02 & keep the rest
123104516 to be 01223104516
No Zero at the beginning (Cell Contains 9 Digits ) Must Start with Zero ( to be 10 Digits)
1223104516 to be 01223104516
No Zero at the beginning ( Cell Contains 10 Digits ) Must Start with Zero ( to be 11 Digits)
After all that
I need a formula to Lookup at each cell to Do the following :
any Cell Starts with Zero & contains 11 Digits to stay as it is because that's correct No.
any Cell Starts with Zero & contains 10 Digits is not Correct & must be changed as Following
Starts with To Start with & the rest as it is
012 0122
017 0127
018 0128
010 0100
016 0106
019 0109
011 0111
014 0114
0150 0120
0151 0101
0152 0112
Example Result
0123104516 01223104516
Simply I need Someone who is Expert in Excel Formulas
Hi Sir I have thoroughly understand the problem and write the formula to give the desired result . Thanks
Relevant Skills and Experience
Excel, VBA
Proposed Milestones
$49 USD - ON Completion
$49 USD in 3 days
4.9 (286 reviews)
6.3
6.3
29 freelancers are bidding on average $87 USD for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement.
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$250 USD - payment once project delivered
Hi,
I understand the project requirements and willing to start as soon as possible.
Looking forward to work with you.
Thanks & Regards
Khushi
India
Relevant Skills and Experience
excel
Proposed Milestones
$105 USD - milestone
Hey There,
Thanks for posting the project. Its looks feasible and am Interested to do it.
I am an excel/word/outlook VBA automation professional having 7+ years of experience
Relevant Skills and Experience
Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output.
Proposed Milestones
$50 USD - 1
Hi,
I am a highly trained on Data Entry ,Data Analysis, Data Mining, Research, Web search, Web scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel and PDF.
Kind regards,
Fatima
I can format all the phone numbers as per project description. Please send me the complete data files, I will format all the numbers and send a single file to you.
Relevant Skills and Experience
Excel, data processing
Proposed Milestones
$66 USD - default
Greetings
Hope you are doing well.
I am a CPA (CA/ACCA) Finalist and I provide a range of services, majorly focusing on excel, accounting, financial management, cost accounting and other allied subjects. I have been working in the above fields for 3 years now and have an extensive experience in the same.
Looking at the project description, I am quite certain that I can execute it with utmost responsibility. Being proficient with Microsoft Excel and having created several complex excel templates for a series of clients will be an added advantage.
I do not have any working hours constraints which will help in keeping you in loop as i ll be working according to the required time zone.
Looking forward for your reply in order to discuss the same in details.
Regards
Jitin Goyal
Hi Sir;
I read the project description. I understand the project needs completely. I have also seen the Excel file, but I don't know Arabic.
Relevant Skills and Experience
I have sound knowledge of MS Excel and I am sure that this skill will surely help me in completing the project with perfection.
Proposed Milestones
$250 USD - Completed Project
I would request you to trust in my abilities and offer me the responsibilities of the project.
Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . I believe that , I can do this work properly and in timely according to your instructions. Always determined to give you the best work . Moreover , I have a group which consist of 6 members. Eagerly waiting for your response to start the project . Many Thanks.
I am skilled in Excel formulas can deliver you high quality work within a short time
Relevant Skills and Experience
Excellent in using excel formulas
Proposed Milestones
$155 USD - in one day
Hello Friend,
I am web developer in php and good web designer. I am follow the software development approach requirement gathering and analysis, design, implementation or coding,testing,deployment,Maintenance.I easliy to redesign the website according to client.
I have following skills:-
1. HTML/CSS for designing purpose
2 PHP implementation or coding.
3. Bootstrap framework for mobile responsiveness
4. Javasrcipt/J query.
5. WordPress Framework
6. PSD TO HTML
7. We are provide the technical support and email support.
Depending on your file format, this looks like it is more suitable for python or some simple DB environment. This should not be hard to do.
Relevant Skills and Experience
I deal with scientific data professionally and several data types. It would be easy to build in a couple of filters to sort and then treat depending on the condition of the phone number in the entry
Proposed Milestones
$50 USD - Test on subset of dataset for all problematic data types
$16 USD - Clean up process and apply to entire dataset
What I can give you:
• Auto Tading Strategy Testing System in Excel.
• Warehouse Stock Management System in Excel.
• Auto Data Collection & Management System Specially Hug of Data in Excel
• Any Automatic Processing design in Excel.
I have been working with these stuffs for several years and love to have more chance to solve any your idea or problem of Excel VBA.
If you got ANY idea or problem of Ecxel auto working design or work. Feel free to ask me. I love solving problem.
I have excellent knowledge of ms Excel macros with excellent typing speed. I can assist you with any kind of data entry work, Excel Data analysis. I assure you 100% Quality of work delivered.
Relevant Skills and Experience
I have three years of experience in working with ms office tools excel, power-point world etc.
Proposed Milestones
$55 USD - complete work
i can do this project in high way and short time please contact me sir
Relevant Skills and Experience
data entry
Proposed Milestones
$10 USD - milestone
$50 USD - when finish