Đã hoàn thành

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.

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Khai thác dữ liệu, Web Scraping

Xem nhiều hơn: 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

Về Bên Thuê:
( 8 nhận xét ) Petaling Jaya, Malaysia

ID dự án: #20894428

Được trao cho:

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 trong 4 ngày
(166 Đánh Giá)
7.0

58 freelancer đang chào giá trung bình $170 cho công việc này

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 Thêm

$200 USD trong 2 ngày
(714 Nhận xét)
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 Thêm

$250 USD trong 7 ngày
(202 Nhận xét)
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 Thêm

$70 USD trong 2 ngày
(381 Nhận xét)
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 Thêm

$190 USD trong 2 ngày
(234 Nhận xét)
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 trong 15 ngày
(138 Nhận xét)
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 Thêm

$150 USD trong 7 ngày
(51 Nhận xét)
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 Thêm

$250 USD trong 10 ngày
(227 Nhận xét)
6.4
thinkitltd4

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

$500 USD trong 10 ngày
(81 Nhận xét)
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. Thêm

$200 USD trong 7 ngày
(16 Nhận xét)
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 trong 3 ngày
(111 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(79 Nhận xét)
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 trong 3 ngày
(17 Nhận xét)
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 Thêm

$250 USD trong 7 ngày
(25 Nhận xét)
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 Thêm

$100 USD trong 7 ngày
(19 Nhận xét)
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 Thêm

$140 USD trong 7 ngày
(5 Nhận xét)
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 Thêm

$100 USD trong 7 ngày
(10 Nhận xét)
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. Thêm

$250 USD trong 15 ngày
(39 Nhận xét)
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 Thêm

$50 USD trong 2 ngày
(31 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(9 Nhận xét)
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 trong 3 ngày
(3 Nhận xét)
3.6