Software

Ask something
Question Locked

How can we Sort in Excel?

0 helpful
5 replies

by mdahmed1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can we sort by taking middle words in Excel? Example the different words are like this, Doc-Gen-001, Mat-Gen-007, Drw-Gen-010 i want to sort it by GEN, is this possible in Excel?

5 replies

by sathis2study

u can add the word "GEN" in the custom sort -- order -- custom list add the new word..
enjoy

by mdahmed1

There is no option to add words we can only add the columns which is already exists there....

by varseller

In the field net to the column you want sorted, use the MID function to extract the middle words you want to sort on. In your case, if A1 contains the term Doc-Gen-001, then =MID(A1,5,3) in B1 will give you GEN. Just copy the formula next to the list and then include the new column in the sort range. GEN and every other middle term will end up as a sort option.

by sathis2study

r u using msexcel 2007 .. i have tested in that ..
1.select the column right click
2. select sort and custom sort.
3. sort dialog box will be opened in that order will be there
4.select the order drop down box in that custom list select that
5.then custom list dialog box opens in that add the word "Gen" select add and ok
6. then ok.. it will be sorted !!!!!

This discussion is closed to new replies.