Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
Can you sort text in a column, but leave cell color alone? | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |