Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a Word doc to a multi-column Excel spreadsheet | Excel Worksheet Functions | |||
converting word table to excel | New Users to Excel | |||
Converting a word table into excel | Excel Discussion (Misc queries) | |||
Converting labels from Word to an Excel spreadsheet | New Users to Excel | |||
Can I import a Word table to an Excel spreadsheet? | Excel Worksheet Functions |