+ Reply to Thread
Results 1 to 7 of 7

Convert Table of Contents from Word to Excel

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Convert Table of Contents from Word to Excel

    I have a large word document that is formatted with a table of contents section

    1.
    1.1
    2.
    2.1.1
    2.1.2
    ....

    I want to convert this into an excel spreedsheet (simple part) however I want to order it so the reference number and title appear in Column C, while the associated data goes into Column D.

    Extra credit: Get the reference number in Column C, the titles in Column D, and the data in Column E

    Any Ideas?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert Table of Contents from Word to Excel

    Hi,

    Upload the Word document. It's always easier if we can see the request in context.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    Manama,Bahrain
    MS-Off Ver
    2003, 2007
    Posts
    71

    Re: Convert Table of Contents from Word to Excel

    Hi Kevyn,

    Are you planning to index a word document into Excel?
    Any specific reason for indexing the the document in this manner?


    Regards

    Chuck

  4. #4
    Registered User
    Join Date
    08-06-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Convert Table of Contents from Word to Excel

    I can't due to it being a business related document. But I will attach a generic setup of how it looks on a small scale.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-06-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Convert Table of Contents from Word to Excel

    The reason I want to separate it as mentioned above is to use the excel spreedsheet with an in-house program. (which only accepts documents in this format)

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert Table of Contents from Word to Excel

    That's exactly what I get if I simply copy the word table and paste it into C1 in a worksheet.

    Am I missing something?

  7. #7
    Registered User
    Join Date
    08-06-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Convert Table of Contents from Word to Excel

    I'm talking about the actual body of the page
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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