Sort text in table - ascending results drop to bottom of table!

[Guest]

In a table that has 5 columns (one column being first name and another being
last name of employees) when I try to sort descending by last name the
results work. However, if I sort ascending by the same names, the resulting
sort drops to the bottom of the table with all the empty rows above it. The
results are sorted correctly, but now are at the bottom instead of the top of
the table?!?

 

[Suzanne S. Barnhill]

That's because blanks or spaces have a lower value than any other character.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.