Excel Programming

This project received 55 bids from talented freelancers with an average bid price of $54 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I get several files in excel which have email address in them. I need all the email address consolidated from all the excel file in a single excel file one below the other. The application must have an option to load several excel files together in batches and then extract the email address from each of the excel file into a single excel file. The raw data file structure could be different and may not be same.

Once the email list is loaded into the main master file, if the email address has anything before of after it... it should only take the email address.....example if this is how you see the email address in excel sheet (abcatabcdotcom) tel-- +[url removed, login to view] the final excel sheet must only have

Email address which have more than 20 characters before the "@" sign should be eliminated from the main master file

All duplicates should be eliminated from the main master file

Budget $50

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online