Now I understand

in one cell put =search("y",yourcellreference)+2 (say it is in cell
T2)

this finds the position of the letter y and adds 2 to it

in another cell put =mid(yourcellreference,T2,50)

this gives you the date but in text format (say it is in cell U2)

in another cell put =value(U2) and format this cell to the required
date format

copy paste special values to all these new dates and delete the other
columns, give the new column a heading and now sort as normal.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=525608