Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Prospects by street name
I am trying to sort my list of business prospects by the street name as
opposed to the addres number ex. 1234 StreetName Rd I want to sort by StreeName not 1234 and i just can't figure it out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Prospects by street name
Hi,
Split the address column in two, highlight the address column, then Data, Text to columns, now you can sort by the street name If this was helpful please click yes, thanks "kfroun" wrote: I am trying to sort my list of business prospects by the street name as opposed to the addres number ex. 1234 StreetName Rd I want to sort by StreeName not 1234 and i just can't figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Street Numbers | Excel Worksheet Functions | |||
Sorting Street Numbers | Excel Worksheet Functions | |||
Sorting Street Numbers | Excel Worksheet Functions | |||
Sorting street addresses | Excel Discussion (Misc queries) | |||
How do I sort a column of street number/street name by the stree. | Excel Worksheet Functions |