#1
|
|||
|
|||
Sorting McC... before MAC
Hello!
I have created a booklist for a small school library that has about 1,600 books. Using the sort function, I get this order for the family name: MAYOROS McCAFFERTY The librarian has told me that McCAFFERTY should come before MAYLOROS because of its lower case c. I did a bit of checking on some library sites and found various "rules", depending on library and other things, too... I'm wondering if it is possible to "tweak" the sort order in Excel, i.e., change the alphabetising rules, or are such things set in stone? Thanks in advance! |
#2
|
||||
|
||||
Excel does not have a lexicographical sort function - which is what you are describing. You could, of course, edit the alphabetically-sorted data manually to apply the required lexicographical sorting.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting | gilmourlead | Excel | 3 | 02-17-2016 09:27 AM |
Sorting | texascpa | Excel | 1 | 07-15-2015 12:22 AM |
Sorting Challenge | gbaker | Excel Programming | 11 | 06-22-2012 09:39 AM |
Sorting by certain criteria | randenius | Excel | 2 | 06-11-2012 02:18 AM |
Need help in aplhabetica sorting | brooklyn86 | Word VBA | 1 | 06-05-2012 11:43 AM |