View Single Post
 
Old 07-04-2011, 04:34 PM
Moor215 Moor215 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jul 2011
Posts: 5
Moor215 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Moor215,

To convert the data to a table, I had to do extensive clean-up work first, removing 'headings' embedded in the data, multiple tabs & spaces between 'columns', and also at the ned of each line. Ultimately, each line ended up as basically 'text' tab 'text' tab 'text'. I then selected the whole document and used Word's 'convert text to table' function. Finally, I simply dragged the second column ahead of the first column. Took somewhat less than an hour.

Sorting is easy: Click anywhere in the table, then choose Table Tools > Layout > Sort and choose the sorting arrangement of your preference.
Wow... I can not thank you enough!! My karaoke books are gonna look great because of you. I've been stressing over this for just about 2 months.

Thanks again,
-David
Reply With Quote