Help!! sort address field by street, then number??

[Keefer]

Is there a way to accomplish this feat??
cell data
"7004 Brookville Rd"
need the file by street name , then by number.

All suggestions deeply appreciated.

Keef

[Dave Peterson]

If you're lucky you could use Data|Text to columns.

To separate pieces into individual columns.

But I've never been lucky enough to get 100% -- lots of manual effort may be
required.

Keefer wrote:
>
> Is there a way to accomplish this feat??
> cell data
> "7004 Brookville Rd"
> need the file by street name , then by number.
>
> All suggestions deeply appreciated.
>
> Keef

--

Dave Peterson

[Jim Cone]

Keef,
I've written an Excel add-in "Special Sort" that should do what
you want... it will sort by suffix using the last numeric character in
the data as the separator.
You can even presort by the first number group, putting all the
data in true numerical order, then sort by the suffix.
The add-in has a total of 12 different sort methods available.
It looks and reacts similar to the existing Excel sort utility.
Comes with a Word.doc install/use file.
Available -free- upon email request. Remove XXX from my address.

Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX


"Keefer" <dk.weiss@verizon.net>
wrote in message news:Fu1Ze.2874$TQ3.423@trnddc05...
Is there a way to accomplish this feat??
cell data
"7004 Brookville Rd"
need the file by street name , then by number.
All suggestions deeply appreciated.
Keef

[Keefer]

Jim, WOW!!!

This "special sort" is a great tool. Congratulations on an excellent,
intuitive piece of owrk.

Thank you!



"Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
news:OpYKDkKwFHA.3200@TK2MSFTNGP10.phx.gbl...
> Keef,
> I've written an Excel add-in "Special Sort" that should do what
> you want... it will sort by suffix using the last numeric character in
> the data as the separator.
> You can even presort by the first number group, putting all the
> data in true numerical order, then sort by the suffix.
> The add-in has a total of 12 different sort methods available.
> It looks and reacts similar to the existing Excel sort utility.
> Comes with a Word.doc install/use file.
> Available -free- upon email request. Remove XXX from my address.
>
> Jim Cone
> San Francisco, USA
> jim.coneXXX@rcn.comXXX
>
>
> "Keefer" <dk.weiss@verizon.net>
> wrote in message news:Fu1Ze.2874$TQ3.423@trnddc05...
> Is there a way to accomplish this feat??
> cell data
> "7004 Brookville Rd"
> need the file by street name , then by number.
> All suggestions deeply appreciated.
> Keef
>
>