Thread: Sorting Street Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BASR52 BASR52 is offline
external usenet poster
  
Posts: 2
Default Sorting Street Numbers
I'm using Excel 2007. How would I sort the following:

1111th
131st
1st
223rd
2nd
3rd
65th

to get:

1st
2nd
3rd
65th
131st
223rd
1111th


Reply With QuoteReply With Quote