Hire an Excel Expert

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

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

Kemahiran: Excel

Tentang Majikan:
( 2 ulasan ) Cairo, Egypt

ID Projek: #14767211

rohitagarberg

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 dalam 3 hari
(283 Ulasan)
6.3

29 pekerja bebas membida secara purata \$87 untuk pekerjaan ini

schoudhary1553

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 e Lagi

\$250 USD dalam 3 hari
(275 Ulasan)
7.6
SBITServices

It is very simple task. Just need 1 formula Relevant Skills and Experience Excel Proposed Milestones \$30 USD - A

\$30 USD dalam sehari
(379 Ulasan)
7.4
khushh07

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 Lagi

\$105 USD dalam 2 hari
(250 Ulasan)
7.0
avinav606lx

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 dis Lagi

\$50 USD dalam 0 hari
(158 Ulasan)
6.4
fatimatuzzohura

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, Lagi

\$100 USD dalam sehari
(127 Ulasan)
6.2
best4best

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 Lagi

\$66 USD dalam sehari
(129 Ulasan)
6.3
AkilaArun

Hi, I would like to work on the [login to view URL] forward to hear from you. Best Regards, Akila.K

\$35 USD dalam 2 hari
(35 Ulasan)
4.9
\$30 USD dalam 3 hari
(18 Ulasan)
4.5
JITINGOYAL1992

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 w Lagi

\$55 USD dalam sehari
(26 Ulasan)
4.6
\$53 USD dalam sehari
(12 Ulasan)
4.2
kmkhsujon

Dear client, Let me choose, I'll try my best to accomplish this mission. I'll finish it as soon as possible and make preferable to [login to view URL] you in advance for your time and consideration. Relevant Skills and Experien Lagi

\$30 USD dalam 2 hari
(18 Ulasan)
3.6
sathyasingh1991

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 Lagi

\$250 USD dalam 12 hari
(3 Ulasan)
1.9
Cvengmohamed

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

\$60 USD dalam 3 hari
(1 Ulasan)
0.8
miglaniarun027

having good experience in excel

\$55 USD dalam 5 hari
(0 Ulasan)
0.0
\$45 USD dalam 2 hari
(0 Ulasan)
0.0
\$155 USD dalam 3 hari
(0 Ulasan)
0.0
delfinogomes

Hi, I'm very good at working with excel spreadsheets and I can do this job very fast. I'm looking forward to hear more from you.

\$30 USD dalam sehari
(0 Ulasan)
0.0
amittalukdar1978

A proposal has not yet been provided

\$30 USD dalam 3 hari
(0 Ulasan)
0.0
sapanaparmar

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 Exper Lagi

\$55 USD dalam 3 hari
(0 Ulasan)
0.0
sshubhra14

A proposal has not yet been provided

\$122 USD dalam 3 hari
(0 Ulasan)
0.0