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.

a helper column using MID to polulate it.

--
Don Guillett
SalesAid Software

"Darryl" wrote in message
...
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
--
Sincerely, Michael Colvin


"Darryl" wrote:

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.