Alphabetical order in Word

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Which version of alphabetical order does Microsoft Word use?

I thought that alphabetical order was, well, alphabetical order. That’s what I was taught at school and apparently I was taught wrong. There are at least three ways, two used by dictionaries, another by Microsoft and that’s for English alone!

Reading Sue Butler’s delightful book ‘The Aitch Factor‘ I found that there’s more than one alphabetical order! Naturally, that got me wondering which alphabetical order is used by Microsoft Word and Office when sorting.

Alphabetical orders

Look at these two word lists, both have the same words and both are in alphabetical order.

Word%20alphabetical%20order%201 - Alphabetical order in Word

Source: The Aitch Factor and the Macquarie Dictionary.

The left-hand list is in the more common order. Space and hyphens are ignored then the sort order is applied by each letter.

The right-hand list is another alphabetical order, used with some dictionaries. The key or head word (‘bush’) is followed by the key word compounds (‘bush wire’) .

The left-hand list is more common these days. Ms Butler suggest that because spacing and hyphenation can vary too much (we’ve seen ‘bushbaby’ ‘bush-baby’ and ‘bush baby’). But we think it’s also because it’s easier and faster to program on a computer. To replicate the other method takes some work by splitting the entries up, sorting then putting the entries back together.

Sorting in Word

Now we turn to Microsoft Word. You might expect the same words to be sorted using the left-hand or common method. But no, there’s another ‘alphabetical order’ from Word 2013 (using Table | Layout | Sort with Type ‘Text’, English (US, UK or Australian) language and Windows regional settings).

    • bush

    • bush breakfast

    • bush wire

    • bushbaby

    • bush-bash

    • bushed

    • bushwhacker

Why is the Word ‘alphabetical order’ different?

The usual answer

Word, and most computer programs, don’t really sort alphabetically, they sort numerically using the ASCII/Unicode value for each character from left to right. A lower character value comes before higher ones.

‘b’ has the value 98 so it comes before words starting with ‘c’ which is 99. Spaces have an ASCII code 32 so they sort ‘above’ any letters so that explains why ‘bush wire’ with a space in the fifth position is above ‘bushbaby’ where ‘b’ (98) is the fifth letter. For alphabetical sorting upper and lower case letters are treated the same, despite having different ASCII values.

The usual answer is wrong.

Modern software and a multi-lingual world means that things are a lot more complicated. The ASCII or Unicode character value does NOT necessarily determine the ordering of a list. You can try this in Excel by comparing a sorted list of characters with the CODE() or UNICODE() values for the sorted cells; the two lists won’t always be in the same order.

Word%20alphabetical%20order%202 - Alphabetical order in Word

The above example is sorted ‘A to Z’ by the first column but the code values are somewhat mixed up.

What’s going on?

For example, what about ‘bush-bash’ in the Word sorting example above? A hyphen is ASCII 45 so that should sort below spaces but above any letters – but it doesn’t. In a test of single characters (same settings as above), the sort order is space, apostrophe, hyphen, many other characters, digits and finally letters.

We don’t know why ‘bush-bash’ is in that place, perhaps one of our smart readers can figure it out? Presumably it’s some detail in the US English / other English collation settings.

Regional Differences

The Regional Settings affect the sort order (aka collation). The usual advice is to change the Regional Settings in Windows to change the sort order but that’s not necessary since at least Word 2007.

Go to Tools | Layout | Sort | Options to choose the Sorting language.

Word%20alphabetical%20order%203 - Alphabetical order in Word

Curiously, Excel doesn’t have an equivalent setting and you have to rely on the Windows Regional setting.

subs profile e1563205311409 - Alphabetical order in Word
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address