Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I change a sort order?
I am trying to sort a table according to Hike Descriptions. For example, the
table contains the following as the first 2 sentences in the table: Alamo Canyon. Rating D. Alamo Canyon to the Water Tank. Rating C. When I sort the table, the order is: Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. Is there a way to assure that the sort will be as shown in the first case, and not as in the second, which is not what I want? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I change a sort order?
You would need to have the Alamo Canyon in a separate column, and probably
without the period after it, and sort on that column and then on the column containing the balance of the information. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "mjreale" wrote in message ... I am trying to sort a table according to Hike Descriptions. For example, the table contains the following as the first 2 sentences in the table: Alamo Canyon. Rating D. Alamo Canyon to the Water Tank. Rating C. When I sort the table, the order is: Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. Is there a way to assure that the sort will be as shown in the first case, and not as in the second, which is not what I want? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I change a sort order?
I happen to have the same data in Excel, where the hike title is separate
from the description, so I tried sorting on that column (in Excel), but the sort still comes out the same. Any other suggestions or explanation of why the sort does what it does? "Doug Robbins - Word MVP" wrote: You would need to have the Alamo Canyon in a separate column, and probably without the period after it, and sort on that column and then on the column containing the balance of the information. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "mjreale" wrote in message ... I am trying to sort a table according to Hike Descriptions. For example, the table contains the following as the first 2 sentences in the table: Alamo Canyon. Rating D. Alamo Canyon to the Water Tank. Rating C. When I sort the table, the order is: Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. Is there a way to assure that the sort will be as shown in the first case, and not as in the second, which is not what I want? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I change a sort order?
The sort takes the character vale of each character in turn. The space after
Canyon in the first line below has a lower value than the period in the second line (32 against 46) so it comes first in the sort order. If you add a period after Canyon in the first line and resort, the order will change. Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mjreale wrote: I happen to have the same data in Excel, where the hike title is separate from the description, so I tried sorting on that column (in Excel), but the sort still comes out the same. Any other suggestions or explanation of why the sort does what it does? "Doug Robbins - Word MVP" wrote: You would need to have the Alamo Canyon in a separate column, and probably without the period after it, and sort on that column and then on the column containing the balance of the information. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "mjreale" wrote in message ... I am trying to sort a table according to Hike Descriptions. For example, the table contains the following as the first 2 sentences in the table: Alamo Canyon. Rating D. Alamo Canyon to the Water Tank. Rating C. When I sort the table, the order is: Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. Is there a way to assure that the sort will be as shown in the first case, and not as in the second, which is not what I want? |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Can I change a sort order?
Thanks for the explanation. I went back and followed Doug's suggestion more
carefully, i.e., by deleting the final period, and Voila! it worked. It makes sense now in light of Graham's clarification. "Graham Mayor" wrote: The sort takes the character vale of each character in turn. The space after Canyon in the first line below has a lower value than the period in the second line (32 against 46) so it comes first in the sort order. If you add a period after Canyon in the first line and resort, the order will change. Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mjreale wrote: I happen to have the same data in Excel, where the hike title is separate from the description, so I tried sorting on that column (in Excel), but the sort still comes out the same. Any other suggestions or explanation of why the sort does what it does? "Doug Robbins - Word MVP" wrote: You would need to have the Alamo Canyon in a separate column, and probably without the period after it, and sort on that column and then on the column containing the balance of the information. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "mjreale" wrote in message ... I am trying to sort a table according to Hike Descriptions. For example, the table contains the following as the first 2 sentences in the table: Alamo Canyon. Rating D. Alamo Canyon to the Water Tank. Rating C. When I sort the table, the order is: Alamo Canyon to the Water Tank. Rating C. Alamo Canyon. Rating D. Is there a way to assure that the sort will be as shown in the first case, and not as in the second, which is not what I want? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sort numbers in sequential order | Microsoft Word Help | |||
sort tracked changes in cronological order | Microsoft Word Help | |||
Sort order - punctuation | Tables | |||
Custom sort order | Microsoft Word Help | |||
Address Book sort order | Microsoft Word Help |