View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Howard Howard is offline
external usenet poster
 
Posts: 7
Default Converting irregular Word table to spreadsheet

I am using Office Professional Edition 2003

I want to convert a list of members of a club and their contact details into
a spreadsheet database.

The form of each record in Word is: membership type (in upper case), name,
address, phone number (if any), fax (if any), email (if any), for example

ACTIVE
Bill Gates
Office in the Sky
25 The Long Road
The Big City
State, Code
COUNTRY
Phone: 123 4567 8910
Fax: 123 4567 8910
Email:
Each line in each record terminates with a line break, and each record
terminates with a paragraph mark.

The problem is that the records are not uniform because:
a.. the addresses differ in number of lines
b.. COUNTRY is omitted if not USA
c.. the Phone, Fax and Email details are omitted if none
I want to end up with each type, name, address (single field will be OK),
Phone, Fax and Email each in separate fields.

Any suggestions please?

Howard