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
Applicant must know how to read Arabic
Extra : if you can make all the files in one file with classification according to :
Sex , Address , age , Class
Also
I can Send you a only 1 File with Sample & you send me the Formula or whatever the Solution & I will apply , & Job Done
Please before any Apply , have a look at the file attached & see if it is Clear & you can do it :
in 2 ways :
1 - I will send you the whole list of Numbers ( about 3 Million Numbers )
2 - Or you can Put a general Formula or whatever ( you are the expert ) to apply it at any file
I got your point and know how will do it , Kindly send me sample to show you the result
Relevant Skills and Experience
Im familiar with excel sheets and formulas and will give you the results required accurately in only 3 days, Im Egyptian as well so I understand your point
Stay tuned, I'm still working on this proposal.
Hi,
I have gone through the project thoroughly and understood your project requirements. With years of experience and dedicated efforts, I will be glad to offer an outstanding services; if you can be kind enough to shortlist me for this project. Please give me a chance and initiate a chat so we can discuss further. Looking forward to work you. Thanks
It's an easy job for me. I refer to see the actual data, because if the data is not consistent, the formula may not work in all fields.
By the way, there's no file attached.
Relevant Skills and Experience
I'm and Excel expert, Egyptian and, of course a native Arabic speaker
Proposed Milestones
$55 USD - Finish formula or file modification
Hi, I would like to use my experience to serve you better.
As per your requirement, i can complete it by end of the day as I know the formula for that.
Relevant Skills and Experience
-
Proposed Milestones
$155 USD - -
-
Hi, I work from Chennai, INDIA and have working experience in Port Said, EGYPT.
I'm new to Freelancer.com & looking forward for my first assignment from you.
Relevant Skills and Experience
1) I've worked in Port Said, EGYPT before and understand the number change.
2) I've reasonable typing speed and have certificate on MS Excel 2013 Advanced Course
Proposed Milestones
$30 USD - Completion of Scope of Work
1) I hope you referred to Arabic Language for the Number system.
2) When shall i start ?
I have 6years of experience and having good knowledge of data entry. I have good exposure on Excel and analytical skills.
Skills :Excel, pivot table, charts, slicer, v lookup and macros to automate the repetitive type of Excel work.
Experience :spend analysis, petro analysis
I have 7+ year of experience in Manual Excel .. well versed in formulas .. currently working in Motrola mobile company.. my contact number is 9008076076 India brightson
I'm Egyptian Engineer, Can read and write Arabic of course
And I know what you want (we faced the same problem before)
Pls award me the job
I'm hard worker, and honest engineer
Send me the whole list, and I'll do it
Im egyptian with 11 years of experience in retail credit risk, I gained a strong knowledge of managing the reports including the extraction of data and preparing different segmentation reports to analyze the retail life-cycle of the different portfolios
Strong skills using MS Word, Outlook and Excel with its different features and functions in customizing files and building up formulas
I hope that my experience can help your respective business goals and vision
Looking forward to hearing from you