Sorting in Excel spreadsheet

D

Darryl

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.
 
M

Michael

Hi Darryl. You can use a helper column and extract the 5th and 6th
characterrs from your text fields. Assuming your data is in Column A,
starting in A2, in B2 type: =Mid(A2,5,2) and copy down. You can then sort
on Column B. HTH
 
Top