I need to have my printed conference directory converted into an excel spreadsheet that I can upload to my contact management system.
There are 320 pages, with 8 - 10 records per page. A representative sample of one directory page is attached.
All I want are the contact records. I do not want the page formatting information such as page number, page, header, company header, etc.
In some cases, the email address extends to two lines. This should be consolidated into one line, making one complete email address. This is critical.
Break the name into first and last names. Included hyphenated names in last name. Discard middle names and middle initials.
The output record (columns) should be as follows:
Company Address 1
From the attached sample page, the record for Andrew Britt should look as follows:
Last Name Bratt
Title Senior Tax Manager
Company Name ABB
Company Address 1 501 Merritt 7
Address 2 P.O. Box 5308
Email Andrew.Bratt(at)us.abb.com <-------this is NOT my email address
Other info (Income Tax)