#1
|
|||
|
|||
Word document help needed badly.
I have a word document which is 167 pages used for karaoke and it has all the song titles, artist, and song numbers listed in it. The problem is that I need to flip the artist and song name so that artist is listed first then song name then song number... is this possible? And, if so... after that is completed, would there be a way to alphabetize the artist column? I have attached the document so you can see what I am talking about a little more clearly.
Any help would be very much so appreciated. |
#2
|
||||
|
||||
See attached. I converted the document to a table (with a header row), then re-ordered the columns. Amongst other things, this makes it easier to sort the records by artist, title or number (I'll leave it to you to do the sorting). You can delete the cell borders if you don't want them.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
I have been working on this for months and you did half for me in less than 24 hours. Thank u so much!!! |
#4
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
Thanks again, -David |
#6
|
||||
|
||||
Hi David,
FWIW, Excel is better suited to mainatining such a large table IMHO.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
What would I benefit from using Excel instead of word? i am just learning word, and excel...
|
#8
|
||||
|
||||
Hi David,
For one thing, I suspect you've noticed that working with such a large table in Word slows it down dramatically. Excel, being designed to handle much larger data sets than this, would be far faster, especially at sorting the data & re-ordering the columns. It also has functions that can help you find duplicates quite easily, or help with extracting sub-sets of the data.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Quote:
Thanks, -David |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Corrupt word doc! URGENT HELP NEEDED!! | 99nasha | Word | 1 | 03-11-2011 04:24 PM |
Help needed with printing in Word | sophieb | Word | 0 | 11-16-2010 12:52 PM |
MS-Word 2003 Help Needed Urgent | Karthik123 | Word | 10 | 01-26-2010 08:43 PM |
Convert word document to JPEG. The word document may contain headerfooters | vijayaram | Word | 1 | 12-30-2009 08:25 AM |
WORD: Insert pdf document in word document | aacod | Word | 1 | 06-04-2009 12:20 AM |