Converting Word Document into Excel File

[Guest]

I have a Word document that is a membership listing but it isn't laid out in
a table but I'm trying to convert this into an Excel file so I can create a
exportable file for Outlook. I can easily copy and paste between Word and
Excel but this places all the data in separate rows rather than columns with
headings (i.e., Company Name, Address, etc.).

Thanks,

Richard

 

[Jezebel]

There are no automatic functions in Word or Excel for this. Probably easiest
to fix at the Excel end --

1. Paste your data as it stands, eg into A1, A2, A3, etc.
2. Tag the first entry for each membership, eg by adding and asterisk to the
start of the name.
3. Add formulas to the adjacent cells in the first row: in B1 use '=A2', in
C1 '=A3', etc.
4. Copy the formulas downwards.
5. Sort the lot, so the tagged rows all come together.
6. Delete the untagged rows.
7. Remove the tags.

 

[Ed]

Would Word's Text to Table help at all?
Ed

There are no automatic functions in Word or Excel for this. Probably
easiest to fix at the Excel end --

1. Paste your data as it stands, eg into A1, A2, A3, etc.
2. Tag the first entry for each membership, eg by adding and asterisk to
the start of the name.
3. Add formulas to the adjacent cells in the first row: in B1 use '=A2',
in C1 '=A3', etc.
4. Copy the formulas downwards.
5. Sort the lot, so the tagged rows all come together.
6. Delete the untagged rows.
7. Remove the tags.

 

[Jezebel]

Word's text to table is essentially similar to copying and pasting into
Excel: it checks for tabs as delimiters and uses those to create the
columns. If your items are on separate lines, then you'll get one table row
for each.

 

[Guest]

Thanks for the great suggestion. I've already copied them into Excel and your
suggestion should make it easier than copying and pasting each row of
information individually for 37 pages worth of contact info.