Sorting Prospects by street name

[kfroun]

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]

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