+ Reply to Thread
Results 1 to 4 of 4

Importing an indented outline from Word

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    25

    Importing an indented outline from Word

    I have a word document that is in a basic outline form with indentations for each level of the outline. Here's a sample of what I'm talking about.

    ADEPHAGA Schellenberg, 1806
    *GYRINIDAE Latreille, 1810
    **SPANGLEROGYRINAE Folkerts, 1979
    **GYRININAE Latreille, 1810
    *HALIPLIDAE Aubé, 1836
    *TRACHYPACHIDAE C.G. Thomson, 1857
    *NOTERIDAE C.G. Thomson, 1860
    **PHREATODYTINAE Uéno, 1957
    **NOTERINAE C.G. Thomson, 1860

    This forum won't display it tabbed out, so i put in an asterisk* where a tab would be.
    There's about 12 pages of this. I would like to bring this into Excel so that it looks like this (a dash indicating a new column).

    ADEPHAGA Schellenberg, 1806 -GYRINIDAE Latreille, 1810 -SPANGLEROGYRINAE Folkerts, 1979
    ADEPHAGA Schellenberg, 1806 -GYRINIDAE Latreille, 1810 -GYRININAE Latreille, 1810
    ADEPHAGA Schellenberg, 1806 -HALIPLIDAE Aubé, 1836
    ADEPHAGA Schellenberg, 1806 -TRACHYPACHIDAE C.G. Thomson, 1857
    ADEPHAGA Schellenberg, 1806 -NOTERIDAE C.G. Thomson, 1860 -PHREATODYTINAE Uéno, 1957
    ADEPHAGA Schellenberg, 1806 -NOTERIDAE C.G. Thomson, 1860 -NOTERINAE C.G. Thomson, 1860

    Each level of the outline (the number of tabs indented) would get put into its own column. It would also be nice to take that one step further and break out the Lowercase names and years into their own columns as well.

    Am I asking for a miracle here?

    Any help would be appreciated.

    Thanks,

    Marc
    Last edited by Andelousiano; 01-22-2014 at 03:41 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Importing an indented outline from Word

    Hi Marc

    Welcome to the forum.

    No, you are not asking for a miracle, just for someone with a twisted mind with too much time on his hands - and then hope that he does not realise until it's too late just how much he has taken on!

    I have done what I believe you have asked - I hope it's what you want.

    Regards
    Alastair
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: Importing an indented outline from Word

    This is a great help. But I still have one problem. When I paste the original outline into excel, everything gets put into column A. For your macro to work, the indented items need to already be in their appropriate columns. How do I paste so that each column represents an indentation?

    Thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Importing an indented outline from Word

    Hi Marc

    I see your problem. I had started from your file which clearly shows the one or two tabs. I have Googled MS Word and can find nothing that helps. I know what I need to run a macro in Word:

    MS Word macro
    Please Login or Register  to view this content.
    You can then copy the text to Excel and use Text to Columns with # as the deliminator.

    So all you need to do is to find out the reference for the position of the cursor. (Let me know if you succeed!)

    As a work around you can do it manually - I hope you do not have too many rows.

    Sorry not to have been more help

    Regards
    Alastair

+ 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. Group outline between word
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2014, 12:53 AM
  2. Can i Record sound in Word outline mode
    By Reema in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2009, 04:49 AM
  3. Convert PivotTable to MS Word Outline?
    By ComcoDG in forum Excel General
    Replies: 0
    Last Post: 03-26-2009, 04:44 PM
  4. Removing outline of the cell when pasting in Word
    By luckster in forum Excel General
    Replies: 1
    Last Post: 04-02-2008, 11:05 PM
  5. totaling indented subsections
    By steev_jd in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 03:09 PM

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