Hi,

I have a Word Document (Office 2003) with lots of names and addresses that I
need in Excel so I can add them to another list to do a data import.

The data in Word is like this:

Joe's Bar and Grill
1000 Somewhere Dr
City ST Zip
Contact: Joe Schmoe
Phone: 800-000-000
Fax: 800-000-000
County: WhoKnows

If I copy and paste that into Excel, of, it puts it in the same column, each
line on a row.

This is how I need it in Excel (in Columns):

Company Address Contact Phone Fax County
Joe's..... 1000 S... Joe 800-... 800-. Whoknows

I need to get it into columns, but I don't want the words Contact, Phone,
Fax etc to show up next to all the names, phone numbers etc. I hope that
makes sense.

So...how do I do it?

Thanks,

Dan