Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use Excel to convert Word labels into data source (Excel/Word 2000 Win XP)

    Using Word's mail merge features, I easily import information from a Word table, Excel worksheet, or Access database into form letters, envelopes, and label sheets. However, more than once I've needed to move data in the opposite direction: from a Word document to a usable data source. Can anyone help?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Use Excel to convert Word labels into data source (Excel/Word 2000 Win

    Check out <post:=561,052>post 561,052</post:> and the replies for one solution that can be adapted

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use Excel to convert Word labels into data source (Excel/Word 2000 Win

    It depends on the way the labels are set up. I'll assume that the labels contain names and addresses, with multiple lines (actually paragraphs) in a table cell.

    Here is a series of steps you could try:
    - Make a backup copy of the document with the labels.
    - Open the document (or the copy), and select Edit | Replace...
    - Enter ^p (the code for a paragraph end) in the Find what box.
    - Enter @@@@ in the Replace with box (or some other text string that doesn't occur in the label document itself)
    - Click Replace All.
    - Close the replace dialog.
    - Click anywhere in the table.
    - Select Table | Convert | Table to text...
    - Specify Paragraph Marks as separator.
    - Click OK.
    - Select Edit | Replace...
    - Enter @@@@ (or whatever you used above) in the Find what box.
    - Enter ^t (the code for a tab) in the Replace with box.
    - Click Replace All.
    - Close the Replace dialog.
    - You should now have the addresses in single lines, with the data separated by tabs.
    - Select the addresses, and copy them to the clipboard.
    - Paste them into Excel.
    - Alternatively, you can convert the lines into a table in Word again, using Table | Convert | Text to Table, with Tab as separator.

    You often have to perform manual 'data cleaning' afterwards.

  4. #4
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use Excel to convert Word labels into data source (Excel/Word 2000 Win

    Mine is very simple. I have data in a Word document (label Avery 5160) with three columns across and ten rows down = 30 individuals with addresses. There are no numbers with the exception of the zip code but no math to be done to it (treat it like text).

    I need specific, step by step instructions on how to get these names and addresses from Word into an Excel sheet with the following Excel columns: Name, Address, City, State, ZIP.

    That's it. Thanks!

  5. #5
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use Excel to convert Word labels into data source (Excel/Word 2000 Win

    Thanks, Hans. I'll try that!

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •