I have a column with letters
E following numbers, i.e.
4e 5w 6w 7e 7e
, and I want to sort the column into
Any help would be appreciated.
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:
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