Käynnissä

Do some Excel Work

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

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: work freelance translator venezuela, macros work excel internet, freelance work excel vba, track work excel, contract work excel access, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

About the Employer:
( 8 reviews ) Petaling Jaya, Malaysia

Projektin tunnus: #13087530

Myönnetty käyttäjälle:

best4best

Hi, Please share both the Excel files, I am an Excel expert and can arrange the email data from file2 to file1 as per your instructions with great accuracy. Regards Rav

180 RM MYR 1 päivässä
(174 arvostelua)
6.4

62 freelanceria on tarjonnut keskimäärin 442 RM tähän työhön

mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Lisää

390 RM MYR 6 päivässä
(94 arvostelua)
6.5
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

800 RM MYR 1 päivässä
(110 arvostelua)
6.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Lisää

200 RM MYR 1 päivässä
(97 arvostelua)
6.1
ansarrali

Hi, hope you doing great. I can get all the emails required. I assure you the accuracy in my work. Kindly, provide me this opportunity. Thank you. Kind Regards, Ali

850 RM MYR 5 päivässä
(42 arvostelua)
5.5
abdussamad

Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber, blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO, and technical / help Lisää

500 RM MYR 5 päivässä
(36 arvostelua)
5.6
andriphone0

Hi, Please refer to your Message, So we can create sample work right away before awarding the project. I have read description carefully and I understand your project concern and ready to start immediately. I w Lisää

513 RM MYR 1 päivässä
(42 arvostelua)
5.2
mariusalex86

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 Lisää

825 RM MYR 8 päivässä
(30 arvostelua)
4.5
shanthimv

Hi, I would like to work in this project. I have got your requirement clearly and is well explained in the description. I assure you that I will update file 1 with all the emails from file 2 to the appropriate domai Lisää

500 RM MYR 3 päivässä
(7 arvostelua)
4.5
116 RM MYR 1 päivässä
(12 arvostelua)
3.9
rafeemd

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.

194 RM MYR 3 päivässä
(2 arvostelua)
2.2
suryasalur

I had good experience with this type of job can update 80k rows and can also update post codes

500 RM MYR 13 päivässä
(5 arvostelua)
1.6
htiwary

I had just completed australian estate agency work where i had listed around 10K agents and their full details and for that i had visited almost 200 websites and that's only in 36 hours. I can assure you of timely a Lisää

513 RM MYR 3 päivässä
(1 arvostelu)
0.4
666 RM MYR 3 päivässä
(0 arvostelua)
0.0
ZuraidaZul

Dear Sir, Your job caught my attention straight away and I have read your job description. I believe that I am a suitable candidate for the job. I'm familiar with excel spreadsheet, data entry & data sourcing. I'm Lisää

500 RM MYR 4 päivässä
(0 arvostelua)
0.0
888 RM MYR 10 päivässä
(0 arvostelua)
0.0
tabishmalick

A proposal has not yet been provided

555 RM MYR 6 päivässä
(0 arvostelua)
0.0
513 RM MYR 3 päivässä
(0 arvostelua)
0.0
Christie17

Hi, I've gone through the project details, and understand what you are trying to achieve. I'd like to speak with you to confirm project. Thanks

222 RM MYR 3 päivässä
(1 arvostelu)
0.0
Blazny

A proposal has not yet been provided

555 RM MYR 5 päivässä
(0 arvostelua)
0.0
toni9007

Hi Sir, So if I understand correctly you want to add the correct e-mail for each of your partners in File 1? But some of them are missing there and they are actually in file 2? I think that I can just use a combinat Lisää

513 RM MYR 3 päivässä
(0 arvostelua)
0.0