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