Question about Sorting...PLS help

[AMD3400]

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

 

[erik.van.geit]

Hi, AMD3400,

could you provide some more information on the "limits" of your data

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
	A	B	C	D
1	8450		8450-k0
2	84500		84500-k0
3	8450-k1		8450-k1
4	8450-k3		8450-k3
Blad2

 

[erik.van.geit]

AFTER SORT

Map1.xls
	A	B	C	D
1	84500		84500-k0
2	8450		8450-k0
3	8450-k1		8450-k1
4	8450-k3		8450-k3
Blad2

 

[AMD3400]

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