+ Reply to Thread
Results 1 to 2 of 2

Converting document to excel and sorting it by paragraph

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    Hephzibah, Georgia
    MS-Off Ver
    2010 at work, open office/google docs at home
    Posts
    1

    Converting document to excel and sorting it by paragraph

    I have a document that I have to copy and paste into an excel document from a .pdf.
    It has numbered paragraphs.
    When I copy and paste it, each line gets its own cell.
    That means the paragraphs each start with a number and a title.

    (Example:
    1. Title
    whatever data content
    second line of additional content
    even more stuff.)

    I need to sort this document into 3 columns:
    A column with paragraph number.
    A column with the title of the paragraph.
    A column with the data.
    It would generally end up like this:
    |1. |Title|whatever data content second line of additional content even more stuff.|

    The question is: is there a macro that already exist that I can tweak to make this happen? I am real new to macros, and uncertain how to do this. Any solution that will make this easier is acceptable- as long as it uses excel/office. I have over 1000 pages to sort this way.

    I am attaching an excel with an example to explain further if needed. If there is already the same question (or substantially similar) asked and answered please show me the thread because I have not found it.
    ask.xlsx

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,346

    Re: Converting document to excel and sorting it by paragraph

    Does this have to be done in Excel? My first thought is that this might be easier in a word processor (like Word). Copy the material into Word. You may need to clean up any extra carriage returns, then sort the document by paragraph. http://office.microsoft.com/en-us/wo...398.aspx?CTT=1
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Excel Document Converting to .dat
    By sara.leonard in forum Excel General
    Replies: 3
    Last Post: 09-13-2012, 05:17 PM
  2. Converting graphics in an Excel document to text
    By JohnnyBee in forum Excel General
    Replies: 1
    Last Post: 04-23-2012, 07:21 PM
  3. converting a MS word document to Excel
    By jon@karhu in forum Excel General
    Replies: 6
    Last Post: 02-10-2009, 02:55 PM
  4. [SOLVED] Converting a Word Document to excel
    By KelB in forum Excel General
    Replies: 2
    Last Post: 03-13-2006, 05:10 AM
  5. Converting a Word document into an Excel one
    By Rageaholic in forum Excel General
    Replies: 2
    Last Post: 06-20-2005, 05:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1