Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a column with letters W and E following numbers, i.e.


, and I want to sort the column into e and w.

Any help would be appreciated.

share|improve this question
A helper column (containing =RIGHT(A1,1) copied down) may suit [and A1 if necessary adjusted to suit]. – pnuts Apr 19 '13 at 15:53

Select your Range and go to Data>Text in Rows.

Follow the dialogue by selecting Fixed width and setting a dividing line between 4 and e - continue.

Your original column is now split into 2 columns like so:

      A     B
1 |   4     e
2 |   5     w
3 |   6     w
4 |   7     e
5 |   7     e

Then you select the B column and do a Sort A - Z on it - excel will ask if you want to extend your selection to column A - finish by accepting. Done

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .