how do i sort a list from cells by picking a specific letter?

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

Guest

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.
 
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
 
Back
Top