Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Hyphens and apostrophes are sorted after alphabetic letters in Excel


View products that this article applies to.

Symptoms

In versions of Microsoft Excel that are listed in the applies to section, the hyphen character (-) and the apostrophe character (') are ignored when you perform a sort.

↑ Back to the top


More information

This sorting behavior occurs in Microsoft Excel 97, in Microsoft Excel 2000, in Microsoft Excel 2002 and in Microsoft Office Excel 2003. As a result of this sorting behavior, you may experience one or more of the following problems:
  • Cell entries containing hyphens and apostrophes may be sorted differently than they were in earlier versions of Excel.
  • When you compare the relative values of two text strings, you may receive a different answer than you do in earlier versions of Excel.
  • The VLOOKUP function may return a different value than it does in earlier versions of Excel.
This sort order behavior is designed be consistent with Microsoft Windows. Sorting in Microsoft Word 2000 also ignores the apostrophe character and the hyphen character. The sort order in Microsoft Word 7.0 does not do this.

↑ Back to the top


References

For more information about sorting, click Microsoft Excel Help on the Help menu, type sort a list in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB212144, kbprb

↑ Back to the top

Article Info
Article ID : 212144
Revision : 6
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 308