Completed

Excel Expert to Compile List of Email Addresses from Hidden Characters

I have a list of 10K rows of data, that has Email Addresses in one of the column, but those Emails are hidden by ****... Example, one of the cell has following information:

"Employees

Employee Seniority level Email address Phone number Social

Durrah Hamdan

Associate Director - AI and Predictive Solutions Lead

- d*****@[login to view URL] -

Kamraj Subramanian

Associate Director

Director k*****@[login to view URL] -

Yang Zhengzhi

Data Scientist

- zhe*****@[login to view URL] -

Nina Alag Suri

Founder and CEO

CXO nina*****@[login to view URL] - "

Your job is to split out those columns & replace those *** with given name... U may need to calculate how many characters with those *** then replace with the name as per given, certain * could mean . or -, these are common separator in email addresses. So, the use of intelligent formula is important to "guess" the right email.

In the end, we need 1 row of data with Company, Name, Job Title, Email Address... If there are 5 email addresses from same company, it shd have 5 rows of data with 5 different emails (and name & job title) but with same company name.

Although this could be done manually, but remember there are 10K rows, it might mean there could possibly 50K emails to be "guessed"... So Excel expert could do this quicker.

Skills: Excel, Data Entry, Data Processing, Data Mining, Web Scraping

See more: list email addresses germany, mortgage broker list email addresses, list email addresses, list email addresses pakistanis, list email addresses indians, contact list email addresses radio stations, staffing company list email addresses, list email addresses dubai companies contact number lists, list email addresses password 2009, list email addresses business people middle east, broadcast radio stations contact list email addresses free, huge list email addresses, list email addresses sale, list email addresses facebook friends, list email addresses facebook, export list email addresses facebook, list email addresses councils excel

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

Project ID: #20894428

Awarded to:

hdlong66

Hello, I can help to compile list of email addresses from hidden characters. I’m willing to give a sample for your review and comment. Please drop a PM if you’re interested. Best regards, Hoang

$50 USD in 4 days
(166 Reviews)
7.0

58 freelancers are bidding on average $170 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$200 USD in 2 days
(714 Reviews)
8.5
asin1987

Dear Employer, I understand your job and I will get all your 50K email ids rectified through Excel automation. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previou More

$250 USD in 7 days
(202 Reviews)
7.7
prameswara

Hello Sir Im excel expert (VBA macro and formula expert) i can do identify ** in your email by your given name quickly Sir i will have a better way todo that via VBA script or formula please ping me now to make sure a More

$70 USD in 2 days
(381 Reviews)
7.2
devi222

Hi sir, I came to an idea how to get the right emails. I will write formula based on first and last name columns in combination with emails column. I will first split the emails into separate columns then first and sec More

$190 USD in 2 days
(234 Reviews)
7.1
bd100m

Hi, I have a team. I can handle this manually. This is not possible by program. Send me sample file. Waiting for your reply. Thanks

$2222 USD in 15 days
(138 Reviews)
7.0
dvcontact

Hi, I have read very carefully your project details about creating intelligent formula that will guess and compile email addresses from hidden characters. I am absolutely sure that I can complete this project professio More

$150 USD in 7 days
(51 Reviews)
6.4
kalidas365

Hello Sir, Thanks for posting suitable project as per my skill. I am having 10 yrs similar experience and confident to handle this project of 10K data base processing. Please review my similar portfolio and 1130+ posi More

$250 USD in 10 days
(227 Reviews)
6.4
thinkitltd4

I have understand all. message me. i can start new. thanks. ..............................................................

$500 USD in 10 days
(81 Reviews)
6.5
imtiaznafis1

Dear Sir, Hope you are doing well. Sir I am very much interested to work on this project and I ensure my fullest dedication and effort in order to accomplish the 1st 500 emails before you award me the whole project. More

$200 USD in 7 days
(16 Reviews)
5.8
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$194 USD in 3 days
(111 Reviews)
6.3
expertserv

Hello Sir, Ready to start now. I do have a team of 10 experts who can join with us in this project. I will make sure to replace the *** with given name into a well organized excel spreadsheet as per your requirement More

$30 USD in 1 day
(79 Reviews)
6.2
razvancotofana

Hello, I am an excel expert and I can create the required automation for replacing the *** with names. Please share your project files over chat and we can discuss on how to proceed. BR, Razvan

$200 USD in 3 days
(17 Reviews)
5.3
brtodi

Hi, I have gone through the job description and I am clear with it. We are a team of experts data processing members. Have rich knowledge in excel. I have checked google that [login to view URL] email pattern is 1st name at x0pa More

$250 USD in 7 days
(25 Reviews)
5.2
KuldeepGera

Hello, I have read the project description and understood it. I don't think it can be done through any formula or something. It is a whole manual work. I can begin working on it with my team as soon as you hire me. I More

$100 USD in 7 days
(19 Reviews)
4.6
alexwmsoft

Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read your job description, and I am interested i More

$140 USD in 7 days
(5 Reviews)
4.6
writingapp

Hi. I can find business emails from name of employees in a company. Great app writer for your projects. I have writen scraping, excel app, macro, vba for many years. I am ready to write your project. Thank you for visi More

$100 USD in 7 days
(10 Reviews)
4.1
shifa1988

HI, I am expert in MS excel . I did similar job already. so I am a best candidate for this project. I utilize your full requirements and I have 5 members of team to do this manually. even 50 also possible. so relax. More

$250 USD in 15 days
(39 Reviews)
4.7
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you with this. Can you share to me your file? I will check if I can create a formula or codes to do it quickly. Please consider my bid. I've done a lot of Repor More

$50 USD in 2 days
(31 Reviews)
4.3
amuratagic

Hello Sir, I have 2 years of experience working with Python and I can create a script that does the job that you described. Script will complete this work much much faster than any manual work, plus at the end you will More

$30 USD in 1 day
(9 Reviews)
3.9
bjena

I am an experienced freelancer having experience in PHP development, Database, Web Research and Excel. Please send me the worksheet . I can do it easily using formula. Thanks.

$140 USD in 3 days
(3 Reviews)
3.6