Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-01-2017, 04:55 AM
Peace Freak Peace Freak is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Apr 2017
Posts: 5
Peace Freak is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 10-04-2017, 02:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,648
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

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


All times are GMT -7. The time now is 03:45 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft