| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sort question
Hi,
I have one column called 'ID'. ID is like A1, A2...B10, B11.... each ID has one alphabet + number(s). When I sort this column, I end up data sorted like...A1, A10, A11....A2, A21, A23....A3, A31....B1, B11.... I have to manually move data around because I want see them as A1, A2....A10, A11...A20, A21...B1, B2...B10, B11.... What should I do? Please help. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Sort of format Question | Excel Worksheet Functions | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Lookup and Sort Question | Excel Discussion (Misc queries) | |||
Threaded Mode
