I have 188 pages of contact information in a word document that I am trying to get into a preformated Excel file. Here is what the Word doc looks like (188 pages worth):
Steven Brown, Member
Office of Policy & Planning, Port Authority of New York & New Jersey, The
233 Park Avenue South 11th Floor
New York, NY 10003
Phone: (212)-435-4411 Fax:
E-Mail: sbrown@panynj.gov
Region: Northeast
J. Russell Bruner, Member
Senior Vice President, Line Management, Maersk, Inc.
Giralda Farms, Madison Avenue P.O. Box 880
Madison, NJ 07940-0880
Phone: (973)-514-5485 Fax: (973)-514-5675
E-Mail: namlintop@maersk.com
Region: Northeast
Domenic T. Bua, Member
Vice President, Gordon, Bua & Reed, Inc., Div. of TranSystems
34 Salem Street
Reading, MA 01960
Phone: (781)-944-7110 Fax: (781)-944-6708
E-Mail: dtbua@transystems.com
Region: Northeast
I need this to fill into an Excel sheet that has columns for each specific type of data (First name, Middle, Last Name, Title, Company, etc. etc.)
I have to do this once a month, so I need something fairly automated. Otherwise, I am looking at 12 hours or more of pure cut/paste. Any help will be greatly appreciated.
Thanks
Greg
Steven Brown, Member
Office of Policy & Planning, Port Authority of New York & New Jersey, The
233 Park Avenue South 11th Floor
New York, NY 10003
Phone: (212)-435-4411 Fax:
E-Mail: sbrown@panynj.gov
Region: Northeast
J. Russell Bruner, Member
Senior Vice President, Line Management, Maersk, Inc.
Giralda Farms, Madison Avenue P.O. Box 880
Madison, NJ 07940-0880
Phone: (973)-514-5485 Fax: (973)-514-5675
E-Mail: namlintop@maersk.com
Region: Northeast
Domenic T. Bua, Member
Vice President, Gordon, Bua & Reed, Inc., Div. of TranSystems
34 Salem Street
Reading, MA 01960
Phone: (781)-944-7110 Fax: (781)-944-6708
E-Mail: dtbua@transystems.com
Region: Northeast
I need this to fill into an Excel sheet that has columns for each specific type of data (First name, Middle, Last Name, Title, Company, etc. etc.)
I have to do this once a month, so I need something fairly automated. Otherwise, I am looking at 12 hours or more of pure cut/paste. Any help will be greatly appreciated.
Thanks
Greg