sorting data

  • Thread starter Thread starter Ruthie
  • Start date Start date
R

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!
 
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
Click to expand...

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.
 
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)?
 
Back
Top