I need some raw data formatted into an Excel Spreadsheet.
I have attached examples:
- Raw Data In .txt format
- Data Formatted in an unprotected Adobe Acrobat PDF File
- Final Excel Spreadsheet
There will be 307 pages of data like the PDF attached which need to be entered into the excel spreadsheet.
A few notes:
In the example excel file, the field "Address1" should always be the PO Box address, if there is one and "Address2" should always be the physical address, if there is one.
Also, Phone1 should be the phone number that is bold (if there is one) and Phone2 can be any additional phone numbers. If there is more than 2 addresses per company, they can be omitted, same goes for more than 2 phone numbers.
Also, please omit all characters such as . - ( ) when entering into excel.
Ex: (310) 255-5620 ---> 3102555620
P.O. Box 2159 ---> PO Box 2159
554 N.E. 4th St. --> 554 NE 4th St
Please let me know if you have any questions.
When bidding be sure to include the price to complete the project, and how long it will take to complete.