Project Description:
This project must be completed in 10 hours and requires a team of at least 3 or 4 people proficient with excel.
We have a file that contains about 15k records. These records consist of company name, phone and address.
The address field needs to be reorganized.
Right now the "address" field has the entire address in one cell.
The address needs to be separated into:
Address
Address 2
City
State
Zip Code
Country
Example:
1333 N. McKinley St.
Suite 109
Phoenix
AZ
85009
USA
You must be able to complete this project quickly and accurately. Most of this can be completed with the "Text to Columns" feature in Excel.
Your work will be checked for accuracy. All final data must be organized and formatted correctly.
Project must be completed in 10 hours. no exceptions. We will immediately send file to selected bidder.
