Ascending Order

i got data something like this...

m4-1
m4-10
m4-100
m4-2
m4-3
m4-30

i try to arrange it in ascending order...

m4-1
m4-2
m4-3
m4-10
m4-30
m4-100

any vba can help? it cant be solve using sort

you could setup a hidden column and sort on that column
at the moment its sorting by text

try in a new cell

=value(mid(Cell, 4,20))
and then sort on the new column

Originally Posted by etaf

you could setup a hidden column and sort on that column
at the moment its sorting by text

try in a new cell

=value(mid(Cell, 4,20))
and then sort on the new column

tq for your reply, but actually i still have other value like M3-1 , M3-4, M3-10.. i cant use your method to solve it

so long as the first characters
M?- is only 3 characters , then it will work

Originally Posted by etaf

so long as the first characters
M?- is only 3 characters , then it will work

not really understand..can explain in detail??

i'm removing the first 3 characters - so it will work for M3- M4- anything with 3 characters

and if you always have a - before the number , then we can change so it can work with any text string length -

give it a try and see what happens

nope.. m3-10, m4-10.. this kind of condition will be duplicated right??

OK , I see what you mean
so then i guess a VBA solution would be better
although 2 helper columns
one with
=left(cell,2)
and the second
=value(mid(Cell, 4,20))

and custom sort 1st column and then add 2nd column as next level sort
then you get

M3-10
.
.
M4-10
.
.
M5-10
etc