Skip to main content
mandrill22
Inspiring
May 6, 2010
Answered

How to populate a table column with marked text?

  • May 6, 2010
  • 1 reply
  • 831 views

I hate searching and typing so I was just wondering if there was a solution to the following problem.

I have a document that contains 5-character defect codes in the body of the text (in numbered steps). At the end of the document I have a table which summarizes these codes: the codes make up one column and the other columns contain information related to these codes (page number, area, actions to be taken, criteria for defect etc.).

Is there a way for me to mark the codes such that I could import all of them into the defect code column?

I was leaning towards generating a list of some kind and then pasting it in the column but I can't seem to paste my generated list into multiple cells. FM will only allow me to paste the whole list in one cell. Am I using the wrong approach or maybe missing a step in between?

    This topic has been closed for replies.
    Correct answer Van Kurtz

    I suggest Arnis's second approach, especially if a particular code is

    used in more than one place in the text. If so, you could do an INDEX of the codes, instead of a

    list, which would give you all the pages where each code appears (following each code). This avoids having to organize the list.

    Van

    1 reply

    Arnis Gubins
    Inspiring
    May 6, 2010

    Any reason you can't use cross-refs (in the summary table) to the actual contents to get them in that way?

    Otherwise, use the convert to table function to change the codes list into a one-column table, copy the column, paste it in to the summary table and then revert the list (or delete it or whatever) back to paragraphs.

    Van Kurtz
    Van KurtzCorrect answer
    Inspiring
    May 6, 2010

    I suggest Arnis's second approach, especially if a particular code is

    used in more than one place in the text. If so, you could do an INDEX of the codes, instead of a

    list, which would give you all the pages where each code appears (following each code). This avoids having to organize the list.

    Van

    mandrill22
    Inspiring
    May 6, 2010

    Thanks, that is what I wound up doing since it met my criteria for minimal clicking and typing. Basically, I wish this document would just write itself without my intervention.