I have a multi-column sheet with 326 rows that I am attempting to sort by:
State, City and Name. Currently the values for State are limited to "NJ".
If I sort by the above order there are eleven rows of data that are not
sorted correctly. They occur about 2/3ds of the way down the sheet.

I have already tried changing formats to text and number, copying and
pasting into another workbook as values. No fix. It does work normally if
you copy and paste into Word. But if you copy and paste back into Excel it
reverts back.

Any ideas on the cause and remedy would be greatly appreciated.