Sorting in Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP !!! SUMIF or SUMPRODUCT 3
excel is only sorting some columns - please help 5
dates and conditional formatting 3
Export excel file to txt 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to group similar column titles together???? 2
Keep cell position in a formula after data is deleted 2
Format Cell 1

Back
Top