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

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
 
G

Guest

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.
 
M

MartinW

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
 

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

how do i lock a sort, ie no header row 1
Specific sort order 5
How can I sort a list of numbers by the last 4 digits? 2
How do I sort by location within a cell in Excel? 2
Sort by number not by letter (C1, A2, B3, D4) 3
How do I sort alphabetically by last letter in Excel? 3
Sort a list by comparing two cells. 1
Sort a list with cells referring to others cells 6

Top