+ Reply to Thread
Results 1 to 3 of 3

Word Table to Excel

  1. #1
    Registered User
    Join Date
    02-08-2022
    Location
    Maine
    MS-Off Ver
    2019 Professional Plus
    Posts
    4

    Word Table to Excel

    Hi all,
    I am hoping someone has some thoughts. I know how to copy and paste a word table into excel, but I have a few hundred pages of reference lists that go back to the early 90's from multiple team members and I am trying to streamline the process for the team by putting it in excel vs a word document so I am combining several different word documents that they've all done their reference list with tables within the word document.
    I have attached a sample copy of the tables I am working with in word, the column I highlighted in yellow is the issue, the TEST SITE and the TEST DATA are all distorted when I copy the table into excel. I've tried in excel to merge them, that does not work either.
    Anyways, just looking or help to be able to quickly to this project.
    Katherine
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,158

    Re: Word Table to Excel

    Word tables and Excel tables are not the same so Excel does its best to do something sensible when it sees differences. In particular what is giving you trouble is that you have paragraph marks in your Word table. (If you do not have them visible, go in the Ribbon to Home > Paragraph and click the little ¶ icon to see them in your table.) Excel thinks that means they should be separate cells, so you get this weird mish-mash of merged cells.

    To fix this for export, replace the paragraph marks with a different character, then change it back in Excel.

    In Word:

    Home > Editing > Replace
    Find What: click Special and select paragraph mark. You should see ^p appear in the box
    Replace With: ###

    The ### is just arbitrary. You can use any string that does not otherwise appear anywhere in your document.

    Copy table
    Paste into in Excel

    In Excel:

    Home > Editing > Find and Select > Replace

    Find What: ###
    Replace with: Hold down the ALT key and type 010

    Now Replace All
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-08-2022
    Location
    Maine
    MS-Off Ver
    2019 Professional Plus
    Posts
    4

    Re: Word Table to Excel

    Jeff, thank you so much. That worked absolutely AMAZING!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 10-10-2021, 11:49 PM
  2. [SOLVED] Copied excel table to Word, but need Word opening in landscape
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-17-2018, 08:58 AM
  3. Problems exporting a table - find/replace data inside a table in word through excel vba
    By elvagonumero1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2018, 04:33 PM
  4. Extract Word header table data to excel (closed word document)
    By Yakov on Excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2017, 02:12 PM
  5. Deleting/removing content on Word table using Excel VBA (not Word VBA)
    By frankyuen1028 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2016, 06:28 AM
  6. Convert Word to Excel based upon Word Table of Contents
    By jcappuccino7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 01:25 PM
  7. Replies: 7
    Last Post: 04-21-2009, 02:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1