sorting data

[Ruthie]

Easy basic q1uestion....
Why is that sometimes when I sort a list of names by last
and then first names they will all be in the correct order
for last names. The first names are usually in the right
order, but, every so often one name will always appear at
the end of the list with the same last name. example:
smith alan
smith ben
smith john
smith michael
smith calvin
thanks!

 

[Harlan Grove]

Easy basic q1uestion....
Why is that sometimes when I sort a list of names by last
and then first names they will all be in the correct order
for last names. The first names are usually in the right
order, but, every so often one name will always appear at
the end of the list with the same last name. example:
smith alan
smith ben
smith john
smith michael
smith calvin

If the space between 'smith' and 'calvin' is a nonbreaking space (decimal
character code 160), then it will sort below all other instances of 'smith ...'
in which the space after 'smith' is a normal space (ASCII decimal character code
32). You can convert nonbreaking spaces to normal ones by selecting the range,
running the manu command Edit > Replace, clearing out any existing entry in the
'Find what' box then holding down an [Alt] key and using the numeric keypad to
enter 0160, move to the 'Replace with' box, clear any existing entry in it and
pressing the space bar once, then click on the 'Replace All' button.

 

[{*BoB*} OZZIE]

Was the range set correctly? If you missed the one
(Calvin) and its the last one, it won't "move"

Just curious, do you do the sorts separate operations or
together (cause they can be done together)?