Sorting numeric and alphanumeric data

Click DATA, SORT, then OPTIONS. Check the Case Sensitive option. Then click OK twice. A Sort Warning pop-up window will appear. Select the "sort numbers and numbers stored as text separately" option.


FYI: a couple of thing you need to do first.
1. The column should be formatted as TEXT. I don't know if it's necessary, but i think it makes things easier.
2. If you already have numbers entered, you will need to re-enter them to convert it to actual text. In the formula bar you should see a apostrophe in front of the number (example '12345).


I attached a condensed sample spreadsheet so you could see the actual entries. Since all the data in column A is actually text, it sorts exactly like how i wanted.