I have a mailing list that lists street addresses in the following format:

COLUMN C
1 Winding Way
10 Main Street
111 Douglas Court
2 Main Street
23 Douglas Court
200 Winding Way

Can I sort this column alphabetically by STREET?

Warning Back-Up or Save your data before trying this...

With your data in C2:C1000, say
Insert temporarily a new column AFTER C - Which will be D.
Enter into D1 =MID(C2,FIND(" ",C2),50)
and Copy down;
Then Copy D21000, Then Paste-Special Values - Then Delete Col C
HTH


"outfitterim" wrote:

> I have a mailing list that lists street addresses in the following format:
>
> COLUMN C
> 1 Winding Way
> 10 Main Street
> 111 Douglas Court
> 2 Main Street
> 23 Douglas Court
> 200 Winding Way
>
> Can I sort this column alphabetically by STREET?

How about using 'text to columns'?

Data> Text to Column> Delimited > next > Click Space

You will end up with three columns. After you sort them by street, you can
put them together as:

C1 &" " &D1" " & E1







"outfitterim" <(E-Mail Removed)> wrote in message
news1A823DC-1DB8-47CB-84B0-(E-Mail Removed)...
> I have a mailing list that lists street addresses in the following format:
>
> COLUMN C
> 1 Winding Way
> 10 Main Street
> 111 Douglas Court
> 2 Main Street
> 23 Douglas Court
> 200 Winding Way
>
> Can I sort this column alphabetically by STREET?