Thanks guys! I got this sorted ....

=IF(ISERR(SUBSTITUTE((SUBSTITUTE((MID(O3,FIND("Dai ly",O3)+5,11)),"_","/",1)),"_","/",1)),"?",(SUBSTITUTE((SUBSTITUTE((MID(O3,FIND("Da ily",O3)+5,11)),"_","/",1)),"_","/",1)))

cheers,
Mo



Mohammad Rahman wrote:

extract date out of string
20-Dec-09

You guys are awesome.

Please help me with this, i need to get the date out of this file name

C:\Documents and Settings\Rez\Desktop\Excel forum\Queue Performance Phone Daily15_Dec_2009.csv


If you let me know how this works, i will be to do this myself in the future.

cheers,
Mo

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
New IEFT RFC indexed search page
http://www.eggheadcafe.com/tutorials...exed-sear.aspx