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? Thank you

 

[Bob Umlas]

Blanks ALWAYS sort to the bottom. You can select column C, use edit/goto
special, select Blanks, then type ZZ and press ctrl/enter. Then do your
sort. then use edit/replace, enter ZZ for find what, leave replace with
empty & click replace all.
Bob Umlas
Excel MVP

 

[unlikeKansas]

Blanks sort to the bottom, but spaces sort to the top, so instead of typing ZZ as Bob suggests press the spacebar and then press ctrl/enter. Your sort will then put those with a space at the top and you don't have to do the replace after the sort.