Hyphens in Excel Sort

From: Norm Lundquist (NormLundquist_at_discussions.microsoft.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 09:23:06 -0700

Does anyone know why Microsoft would ignore hyphens and apostrophes in the
sort? The help says it was designed to be consistant with Windows. Our
company uses hyphens in certain positions of the product number, so now if we
sort by product number, it ignores the hyphens and screws up the list.

Any suggestions for getting around this and have a sort use the hyphens?

Relevant Pages

  • Re: Hyphens in Excel Sort
    ... "David McRitchie" wrote: ... How about making a helper column and sort on it. ... >> Does anyone know why Microsoft would ignore hyphens and apostrophes in the ... The help says it was designed to be consistant with Windows. ...
    (microsoft.public.excel.programming)
  • Re: Sorting Datagrid With Hyphen / Dash
    ... Regardless of the ASCII value of the hyphen, this sort order is WRONG, all ... the '30-' codes should be together, and all the '303' codes should be ... > underscore(_) character and do comparison. ... > If you change the hyphens to underscore, then you will need to revert ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Collating sequence / sort
    ... Apostrophes and hyphens are ignored, with one exception: ... Maybe you can change the hypen to a different character, do the sort and then ... Dave Mills wrote: ...
    (microsoft.public.excel)
  • Re: Hyphens in Excel Sort
    ... I don't really know where Windows provides for sorting other than ... How about making a helper column and sort on it. ... >>> Does anyone know why Microsoft would ignore hyphens and apostrophes in the ...
    (microsoft.public.excel.programming)
  • Re: "-" ignored in sort
    ... Apostrophes and hyphens are ignored, with one exception: ... > as a sort using column B plus column C. ... > vlookup is considering a sorted array in the same way that SORT is. ...
    (microsoft.public.excel.misc)