ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Prospects by street name (https://www.excelbanter.com/excel-discussion-misc-queries/228681-sorting-prospects-street-name.html)

kfroun

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.

Eduardo

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.



All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com