[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?