Re: Sorting with dashes/hyphens/-'s

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sean E. (ennis_at_escape.ca)
Date: 06/09/04

Next message: corrie: "Problems using outlines on a protected ***"
Previous message: Benoti: "SendMail Macro"
In reply to: Jason Morin: "Re: Sorting with dashes/hyphens/-'s"
Messages sorted by: [ date ] [ thread ]

Date: 9 Jun 2004 09:22:11 -0700

"Jason Morin" <jason.morin@us.exel.com> wrote in message news:<19bdd01c44d71$5e74e9a0$a401280a@phx.gbl>...
> your dilemma, you could use a helper column that
> incorporates the formula:
>
> =SUBSTITUTE(A1,"-",1)
>
> Now select both columns and sort ascending on this new
> column.

Thanks, I'll give that a try.

Sean

Next message: corrie: "Problems using outlines on a protected ***"
Previous message: Benoti: "SendMail Macro"
In reply to: Jason Morin: "Re: Sorting with dashes/hyphens/-'s"
Messages sorted by: [ date ] [ thread ]