sort list/range of number with special characters

[jscc]

dear excelforum,

there is a list/range of data

as ...

100/2012
2/2012
3/2012
99/2012
22/2012
33/2012

when i am trying to sort ascending the list as per column a , it shows the following

100/2012
2/2012
22/2012
3/2012
33/2012
99/2012

_______

the sorting way i am requesting, should be as follows...

2/2012
3/2012
22/2012
33/2012
99/2012
100/2012


thank you.

[Ace_XL]

Use the below in a helper column

=Left(A1,find("/",A1-1)) then sort (ascending) the entire range of data by this column

[jscc]

dear excel forum,

to ace_xl
it does not work, the error is #value!
the cell/range is formatted as text, does that matter
also, will the above formula work if the data includes /2012, /2013, /20122, /20133

to cutter
forum moderator
i did try to delete the repeated thread, i clicked delete thread, but the system did not seem to
accept that
as you can see there were repeated twice!

thank you

[shg]

Post a workbook with an example.

[jscc]

column a

100/2012
2/2012
22/2012
3/2012
33/2012
99/2012
100/20122
2/201222
22/2013
3/201333
99/2011

[Ace_XL]

Here is the formula for the helper column in the attached worksheet

=LEFT(B3,FIND("/",B3)-1)*1

[jscc]

dear ace_xl

i have attached a new file
i clarify my query, sorry if not clear previously

after sorting
either by excel or vba

the data shoud be like...
2/2012
2/2012
2/2012
3/2012
22/2012
33/2012
99/2012
100/2012
22/2013
100/20122
2/201222
3/201333

[Ace_XL]

Well in that case...

Fisrt Sort part b by 'smallest to largest'
Add level
Then, Sort part a by 'smallest to largest'
See attached

[jscc]

dear ace_xl,

thank you
but
i require the following..
not to create 2 extra colums
as the space is limited

is there a way (eg.command button) via vba code