I am only dealing with 1 colum in MS Excel.

I have a colum of job numbers i.e. "ABC123CL" what I am trying to achieve is
sort this list of about 17000 numbers by using the unique 2nd letter from the
right "C".
This will alphabetically arrange in order my list?

Hope you can help?

MS Excel 2003

Hi

If all of your job numbers are the same format, you could use a helper cell,
alongside your data, with:
=MID(A2,7,1)
in it and then sort on that column.

Andy.

"abecus" wrote in message
...
I am only dealing with 1 colum in MS Excel.

I have a colum of job numbers i.e. "ABC123CL" what I am trying to achieve
is
sort this list of about 17000 numbers by using the unique 2nd letter from
the
right "C".
This will alphabetically arrange in order my list?

Hope you can help?

MS Excel 2003

Hi abecus,

With your data in A1 down. In B1 put =MID(A1,7,1)
(That will return the seventh character in your job number)

Copy down as far as needed.
Then sort on column B.
Is that the sort of thing you are looking for?

HTH
Martin