View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darryl
 
Posts: n/a
Default Sorting in Excel spreadsheet

How can I sort by using the 5th char. in a field....WildCard?
I'm working in an excel spreadsheet and have an eleven character field. I'm
trying to Sort by the 5th and 6th character. Can this be done? Are there wild
cards I can use?

I'm trying to sort by State...which is indicated by the 5th and 6th
characters.