Sorting

M

muddan madhu

Hi,

Column A has the following data
ABCD02052008
ABCD02062008
ABCD2062008
ABCD262008

u can make something in the above data i.e, after
the text there are numbers which are in date format ie.,02nd may
2008,
02nd june 2008, 2nd june 2008 & 2nd june 2008

How do I sort based on months ?

Actually in col B I used =mid(a1,7,2) from this i can able to get
result
but for the 3rd cell & 4th cell i am not getting what i need....

Is there any other formula to get the result ?
 
M

Mike H

Hi,

Extract the month number into a helper column using
=MID(A1,LEN(A1)-4,1)
The select the data and helper colimn and sort on that.

Mike
 
M

muddan madhu

Thanks Mike


Hi,

Extract the month number into a helper column using
=MID(A1,LEN(A1)-4,1)
The select the data and helper colimn and sort on that.

Mike










- Show quoted text -
Click to expand...
 
Top