Re: Hyphens in Excel Sort
From: Norm Lundquist (NormLundquist_at_discussions.microsoft.com)
Date: 10/26/04
- Next message: Jake Marx: "Re: How Do I Load A ComboBox On A UserForm"
- Previous message: John F: "Roundup Nesting"
- In reply to: David McRitchie: "Re: Hyphens in Excel Sort"
- Next in thread: David McRitchie: "Re: Hyphens in Excel Sort"
- Reply: David McRitchie: "Re: Hyphens in Excel Sort"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 11:17:07 -0700
Thanks, David! Using the "Substitute" is the only option that sounds good
right now.
As for the first part, I don't understand why it's being consistant with
Windows. What part of Windows sorts like that?
Anyway, thanks for the reply!
"David McRitchie" wrote:
> Hi Norm,
> Kind of hard to answer a rhetorical question that you already answered,
> so I'll try for the second part.
>
> Sorting in Excel and ASCII itself can be very exasperating. As long as
> you would not have a problem with hyphens, spaces, exclamation points
> in the same position. How about making a helper column and sort on it.
> =SUBSTITUTE(A1,"-","!")
>
> Or choose another character to substitute, other than apostrophe or hyphen::
> Actually Microsoft Excel help indicates the following order, which is not
> necessarily my experience for sorting text, in any case you already know
> about hypen(-) and apostrophe(').
> 0 1 2 3 4 5 6 7 8 9 ' - (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ `
> { | } ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
> --
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Norm Lundquist" <NormLundquist@discussions.microsoft.com> wrote in message
> news:27F1663D-6D46-4790-A595-BC08AA7D3721@microsoft.com...
> > 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?
>
>
>
- Next message: Jake Marx: "Re: How Do I Load A ComboBox On A UserForm"
- Previous message: John F: "Roundup Nesting"
- In reply to: David McRitchie: "Re: Hyphens in Excel Sort"
- Next in thread: David McRitchie: "Re: Hyphens in Excel Sort"
- Reply: David McRitchie: "Re: Hyphens in Excel Sort"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
