Alpha Sorting

[additude]

I'm trying to understand why sorting a list of words and sorting the same list of words postceeded with ": " would sort to a different order.

Simple example:
#1.
(Sorted Column A Ascending)
Chocolate
Chocolate Chip
Strawberry
Strawberry Cheesecake

#2.
(Sorted Column A Ascending)
Chocolate Chip:
Chocolate:
Strawberry Cheesecake:
Strawberry:

Any suggestions on how to get the ": " in Example #2. to sort like Example #1. ?

Thanks.

[se1429]

Hi

In this example:

Chocolate Chip:
Chocolate:

The positions 10 in the first line is space while in the second line it is ":".
The space comes first in the collating seq and this is why you get a different sorting order than in the first case.