Thread: How do I sort a column of street number/street name by the stree.

How do I sort a column of street number/street name by the street name. I
want to omit the numeric and sort by the street name in Ecel.

Example: 412 South Street
1512 Mercury Ave

In this example, Mercury Street would be listed first in alpha order.

Create a helper column, say B, and in B1 use

=MID(A1,FIND(" ",A1)+1,99)

copy down and then sort on column B

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JHoleman1" <JHoleman1@discussions.microsoft.com> wrote in message
news:FA16B825-6A07-4175-A562-EEF60E3F79AC@microsoft.com...
> How do I sort a column of street number/street name by the street name.
I
> want to omit the numeric and sort by the street name in Ecel.
>
> Example: 412 South Street
> 1512 Mercury Ave
>
> In this example, Mercury Street would be listed first in alpha order.

I literally copied your formula to my spreadsheet (changing the column and
row number) and nothing happened. Hit enter and my helper column just showed
the formula. I must be doing something wrong. Any other suggestions?


"JHoleman1" wrote:

> How do I sort a column of street number/street name by the street name. I
> want to omit the numeric and sort by the street name in Ecel.
>
> Example: 412 South Street
> 1512 Mercury Ave
>
> In this example, Mercury Street would be listed first in alpha order.

That suggests the column is formatted as text. Edit the B1 cell, F2, and
just hit return.Then copy it on down, then sort.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JHoleman1" <JHoleman1@discussions.microsoft.com> wrote in message
news:AE07D94C-8CB7-4ED2-BCAC-773E76B1F01A@microsoft.com...
> I literally copied your formula to my spreadsheet (changing the column
and
> row number) and nothing happened. Hit enter and my helper column just
showed
> the formula. I must be doing something wrong. Any other suggestions?
>
>
> "JHoleman1" wrote:
>
> > How do I sort a column of street number/street name by the street
name. I
> > want to omit the numeric and sort by the street name in Ecel.
> >
> > Example: 412 South Street
> > 1512 Mercury Ave
> >
> > In this example, Mercury Street would be listed first in alpha order.