[mjreale]

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?

[Doug Robbins - Word MVP]

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?

[mjreale]

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?

[Graham Mayor]

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?

[mjreale]

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?