#### AMD3400

##### Board Regular
I would like to know if it is possible to sort a list from 0-9 then a-z. I may have ask this incorrect, but let me demonstrate to you what i am having problem with or need solution to. I have a list containing 4000 Rows in two columns A and Col B. i want to sort Col A in ascending order from A thru Z. at first it did what i want it to do. Now that i went over and check the sorting list, it's not what i want. What i want is that, sort 0-9, and if there is a - in between it, i want it to go after the previous one. Here is an example. 8450, 8450-k1, 84500, 8450-k3. This is the output of excel. I want is 8450, 8450-k1, 8450-k3, 84500. Is there a way or a macro that can do this? please help. Thanks

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi, AMD3400,

how many numerics are there : minimum / maximum ?
I'm thinking at some "left" and "right" tricks put in another column, perhaps adding some info if no "-" appears, then sorting with the other column (C in the example) as reference ...

the example doesn't quite sort everything like you said but it can give some other ideas ...

perhaps this is already enough to get you started ?
kind regards,
Erik
Map1.xls
ABCD
184508450-k0
28450084500-k0
38450-k18450-k1
48450-k38450-k3

Thanks Erik, this is what i am looking for hehehe cool.

Replies
9
Views
544
Replies
2
Views
654
Replies
4
Views
203
Replies
5
Views
429
Replies
1
Views
249

1,203,072
Messages
6,053,377
Members
444,659
Latest member
vuphihung

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back