LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh Excel Worksheet Functions 0 January 12th 09 06:42 PM
converting word table to excel Happy New Users to Excel 4 December 16th 07 09:39 PM
Converting a word table into excel [email protected] Excel Discussion (Misc queries) 2 September 27th 07 01:39 PM
Converting labels from Word to an Excel spreadsheet Leah Stein New Users to Excel 3 December 20th 06 03:44 AM
Can I import a Word table to an Excel spreadsheet? Liz Excel Worksheet Functions 1 November 25th 04 04:41 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"