Thread: How do I sort postal addresses by street name, then number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
curlydave curlydave is offline
external usenet poster
  
Posts: 206
Default How do I sort postal addresses by street name, then number
Yes the best way would be to separate the first part of the string
You could use text to columns Data=text to columns
Or use this
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))
This will display anything after the first space in the string
Then you can sort
Reply With QuoteReply With Quote