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 D2:D1000, 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?