Do some Excel Work
RM99-825 MYR
Πληρώθηκε κατά την παράδοση
Hi Excel Expert,
We have got a list of business contact information data from some business directory.
I have 2 files:
File 1: It contains full business information, available fields are: Name Address1 Address2 Address3 Address4 Phone Fax Email Website Contact1 Contact2 Position1 Position2 Description Categories
Total rows: 9611 records
File 2: A list of email addresses only
Total row: 80K emails
What I want to achieve:
All these 80K emails (File 2) are generated based on email's domain & websites of File 1. So, there might be more than 1 email from each row of File 1. Example, there might be 10 emails under domain [url removed, login to view] from File2, and we need to add these 10 emails into File 1. Then there's also another 45 emails under domain [url removed, login to view] that I need to add into File 1.
In short, File 1 would be updated to have 80K rows from 9611 rows now, after added 80K emails from File 2. So, u got to add correctly those 80K emails based on domains available in File 1.
Secondly, this is much easier to do, we need to extract out the postcode from Address1 Address2 Address3 Address4 in File 1. Some postcode are on Address2, some postcode on Address3 or Address4. We need to take out the first 2 digit of the postcode and put up on new column.
Let me know your quote.
BR
Travis
Ταυτότητα Εργασίας: #13087855
Σχετικά με την εργασία
34 freelancers κάνουν προσφορές κατά μέσο όρο RM452 για αυτή τη δουλειά
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable and hard working freelancer, focused on quality and accuracy. I will also do my best to finish the work within Περισσότερα
I can do this project. I would like to know whether the emails have to match not only with the website, but also with names in file 1. Please send the files, then I can send some sample work
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
Hello Dear Hiring Manager! I have read your posted job for data entry. I am well expert in this work and I am ready to do work with you. I am totally free and I can start work from right now. I am new on freelanc Περισσότερα
Hey, i am interested in your project. Please send me a message so that we can discuss more details. I have 4 years working experience in this field.
Dear sir/madam,I'm expert to data entry projects,please give me that project,and i would like to do that correctly and neatly
I am delighted to submit this proposal for the Provision of Data Entry services. In this regard, I submit our proposal for the provision of the above services to you and accept the challenge to deliver on our commitmen Περισσότερα
Being a computer science engineer, I think I am more capable to get the project and I have work experience of 2 years also.
Hello I have read your information and I will love to do your work. The main goal is customer satisfaction, I will give numbers of revisions for your work. I am a professional auto cad designer and data entry from la Περισσότερα
Hi, i like to work in excel and i am willing to work for you as soon as i saw your work description. I need a week time to complete this project. you can relay on me, my accuracy is good and i put more effort to maint Περισσότερα
I have hands on with this kind of projects. I can provide you a better data and with the help of my skills i will get the correct email domain. Thanks Debananda
Dear customer, I have a lot of working experience in similar projects. Since you are probably interested in a permanent solution, I recommend a VBA solution embedded in file 1 (unless file 1 gets replaced occasio Περισσότερα