Sorting

[Kim]

I have a list of names like so:

Last Name First Name Middle
Jones Kim A
Jones Kim
Jones Kim D

I am sorting the list by last name, then by first name,
then by middle initial, in ascending order.

It's sorting the list like so:
Jones Kim A
Jones Kim D
Jones Kim

Shouldn't the blank middle initial be first? It's the way
I want it to sort. How can I make that happen?
PLEASE HELP!

 

[Debra Dalgleish]

In Excel's Help, look for the topic "Default sort orders'. This contains
details on the order in which characters, values and blanks sort --
blanks are always placed last.

Instead of leaving the cell blank, you could enter the formula: =""
This will sort before the letters.