IT Logo Top Hermit's Free Library  Brain Teasers

Converting text to table to manipulate columns in a plain text file.

Brain Teaser #8 Solution: Turning the Table on List Manipulation

  1. Select and Copy the data list to the Clipboard (Ctrl-A, Ctrl-C)
  2. Open MS-Word
  3. Paste the list into a new document
  4. Convert text to two column table (separate text at double quotes (")
    How to convert text to a table in MS-Word
  5. Delete the second column
  6. Convert the resulting one column table back to text (separate text with Paragraphs)
    How to convert a table to text in MS-Word
  7. Convert the resulting text to a table (separate text with "-")
    How to convert text to a table in MS-Word
  8. Delete the first column
    How to select and delete a column in a table
  9. Convert the resulting one column table back to text (separate text with Paragraphs)
    How to convert a table to text in MS-Word
  10. Select the resulting text and format it with autonumbering