Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why does Word sort my lists incorrectly?
I have a listing of my DVD collection in word (2000), but when I click on
TABLE, A-Z SORT it does not sort the items correctly. For instance, here is the correct alphabetical sorting sequence for the sample titles below: The Office Christmas Special The Office Complete First Series The Office Complete Second Series Thing, The (R1) This Is Spinal Tap: Special Edition Three Amigo's, The Three Kings Time Machine, The (R1) But, if I sort the above titles in Word, I get the following result: Thing, The (R1) This Is Spinal Tap: Special Edition The Office Christmas Special Three Amigo's, The Three Kings Time Machine, The (R1) The Office Complete First Series The Office Complete Second Series As you can see, the are multiple titles incorrectly sorted. This is just a small portion of my list, This kind of thing happens all the way through it. Sorting options are set to: Sort by: Paragraph Type: Text Sort: Ascending Is this some known bug in Word, and if so is there a fix for it? Mike. |
#2
|
|||
|
|||
Hi Mike,
I tried using both the first and second list sorts in your message and it sorted correctly. If you copy and paste your list from the message you posted into a new blank document and sort it do you get the same problem? What do you have selected under the [Options] button in the Sort dialog? How are you creating and formatting your list? ========= "-mike-" wrote in message ... I have a listing of my DVD collection in word (2000), but when I click on TABLE, A-Z SORT it does not sort the items correctly. For instance, here is the correct alphabetical sorting sequence for the sample titles below: The Office Christmas Special The Office Complete First Series The Office Complete Second Series Thing, The (R1) This Is Spinal Tap: Special Edition Three Amigo's, The Three Kings Time Machine, The (R1) But, if I sort the above titles in Word, I get the following result: Thing, The (R1) This Is Spinal Tap: Special Edition The Office Christmas Special Three Amigo's, The Three Kings Time Machine, The (R1) The Office Complete First Series The Office Complete Second Series As you can see, the are multiple titles incorrectly sorted. This is just a small portion of my list, This kind of thing happens all the way through it. Sorting options are set to: Sort by: Paragraph Type: Text Sort: Ascending Is this some known bug in Word, and if so is there a fix for it? Mike -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* |
#3
|
|||
|
|||
Hi Bob,
I did as you advised and copied & pasted the unsorted list from my post into a new Word document (FileNewBlank Document). I then highlighted the text, and clicked on tablesortok and then a dialog box appeared with the message "Word Found No Valid Records To Sort". I presume by that it assumed the list was already in sorted order. On the sort dialog options I have the following selected: Separate fields at: Tabs Sorting language: English (UK) That is all that is selected. Are you also using Word 2000 Bob? My list is created by just opening a normal Word blank page and by typing the titles in and pressing return after each line. AFAIK there is no special formatting. I'll be happy to email you a copy of the original list in Word format. Mike. "Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote in message ... Hi Mike, I tried using both the first and second list sorts in your message and it sorted correctly. If you copy and paste your list from the message you posted into a new blank document and sort it do you get the same problem? What do you have selected under the [Options] button in the Sort dialog? How are you creating and formatting your list? ========= "-mike-" wrote in message ... I have a listing of my DVD collection in word (2000), but when I click on TABLE, A-Z SORT it does not sort the items correctly. For instance, here is the correct alphabetical sorting sequence for the sample titles below: The Office Christmas Special The Office Complete First Series The Office Complete Second Series Thing, The (R1) This Is Spinal Tap: Special Edition Three Amigo's, The Three Kings Time Machine, The (R1) But, if I sort the above titles in Word, I get the following result: Thing, The (R1) This Is Spinal Tap: Special Edition The Office Christmas Special Three Amigo's, The Three Kings Time Machine, The (R1) The Office Complete First Series The Office Complete Second Series As you can see, the are multiple titles incorrectly sorted. This is just a small portion of my list, This kind of thing happens all the way through it. Sorting options are set to: Sort by: Paragraph Type: Text Sort: Ascending Is this some known bug in Word, and if so is there a fix for it? Mike -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* |
#4
|
|||
|
|||
"-mike-" wrote in message ... I copied and pasted both of your lists into my Word 97 and got "Word Found No Valid Records To Sort". However, when I viewed the 'non-printing' characters I discovered that each line ends with a carriage return rather than a new paragraph. Replacing the carriage returns with paragraphs and then using sort works fine. hope this makes sense. Michael |
#5
|
|||
|
|||
"Gerry Atrick" wrote in message ... "-mike-" wrote in message ... I copied and pasted both of your lists into my Word 97 and got "Word Found No Valid Records To Sort". However, when I viewed the 'non-printing' characters I discovered that each line ends with a carriage return rather than a new paragraph. Replacing the carriage returns with paragraphs and then using sort works fine. hope this makes sense. Michael I think you may have hit upon the answer Michael! I copied the text, then dropped it into notepad (which stripped any non visible characters) then loaded it back into Word as a text find and re-sorted it. Now it seems to be fine. Not really sure where I've gone wrong, or whether there is some kind of operation I can do in Word to remove the problem! Cheers, Mike. |
#6
|
|||
|
|||
On Sun, 02 Oct 2005 19:05:49 GMT, "-mike-"
wrote: "Gerry Atrick" wrote in message ... "-mike-" wrote in message ... I copied and pasted both of your lists into my Word 97 and got "Word Found No Valid Records To Sort". However, when I viewed the 'non-printing' characters I discovered that each line ends with a carriage return rather than a new paragraph. Replacing the carriage returns with paragraphs and then using sort works fine. hope this makes sense. Michael I think you may have hit upon the answer Michael! I copied the text, then dropped it into notepad (which stripped any non visible characters) then loaded it back into Word as a text find and re-sorted it. Now it seems to be fine. Not really sure where I've gone wrong, or whether there is some kind of operation I can do in Word to remove the problem! Cheers, Mike. You can use Edit Replace to do this. Click the More button. Put the cursor in the Find What box, click the Special button, and select "Manual line break". That puts the code ^l in the box. Then click in the Replace With box, click Special, and select "Paragraph mark", which puts the code ^p in the box. Click the Replace All button. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#7
|
|||
|
|||
Hi Mike,
Message in text... On 10/2/05 1:47 PM, in article , "-mike-" wrote: Hi Bob, I did as you advised and copied & pasted the unsorted list from my post into a new Word document (FileNewBlank Document). I then highlighted the text, and clicked on tablesortok and then a dialog box appeared with the message "Word Found No Valid Records To Sort". I presume by that it assumed the list was already in sorted order. On the sort dialog options I have the following selected: Separate fields at: Tabs Sorting language: English (UK) That is all that is selected. Are you also using Word 2000 Bob? My list is created by just opening a normal Word blank page and by typing the titles in and pressing return after each line. AFAIK there is no special formatting. Normally you have to press Shift+Return to put line breaks in your document. Your normal.dot template may contain some style formatting or autotext setting or corruption, etc., to cause it to happen without the shift key being held down. The link below will help you reset your normal.dot file. http://www.officearticles.com/word/a...osoft_word.htm I'll be happy to email you a copy of the original list in Word format. Mike. "Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote in message ... Hi Mike, I tried using both the first and second list sorts in your message and it sorted correctly. If you copy and paste your list from the message you posted into a new blank document and sort it do you get the same problem? What do you have selected under the [Options] button in the Sort dialog? How are you creating and formatting your list? ========= "-mike-" wrote in message ... I have a listing of my DVD collection in word (2000), but when I click on TABLE, A-Z SORT it does not sort the items correctly. For instance, here is the correct alphabetical sorting sequence for the sample titles below: The Office Christmas Special The Office Complete First Series The Office Complete Second Series Thing, The (R1) This Is Spinal Tap: Special Edition Three Amigo's, The Three Kings Time Machine, The (R1) But, if I sort the above titles in Word, I get the following result: Thing, The (R1) This Is Spinal Tap: Special Edition The Office Christmas Special Three Amigo's, The Three Kings Time Machine, The (R1) The Office Complete First Series The Office Complete Second Series As you can see, the are multiple titles incorrectly sorted. This is just a small portion of my list, This kind of thing happens all the way through it. Sorting options are set to: Sort by: Paragraph Type: Text Sort: Ascending Is this some known bug in Word, and if so is there a fix for it? Mike -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* -- Russ drsmN0SPAMikleAThotmailD0Tcom.INVALID -- fix this before replying |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Word have Keyboard Merges like Word Perfect does? | Mailmerge | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |