Sorting

  • Thread starter Thread starter Kim
  • Start date Start date
K

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