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?
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 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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks