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" 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. |
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" 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. |
All times are GMT +1. The time now is 10:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com