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:
Employee Seniority level Email address Phone number Social
Associate Director - AI and Predictive Solutions Lead
- d*****@[login to view URL] -
Director k*****@[login to view URL] -
- 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.
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
58 freelancers are bidding on average $170 for this job
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
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.