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 ?

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

"muddan madhu" wrote:

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 ?

Thanks Mike


On Apr 19, 7:32*pm, Mike H wrote:
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



"muddan madhu" wrote:
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 ?- Hide quoted text -

- Show quoted text -