converting Date to a readable date

[hibindas]

Guys,

I am downloading a file from one software. the date format i am getting in the file is like this [TABLE="width: 71"]
<tbody>[TR]
[TD="width: 71"]21 Jul, 11[/TD]
[/TR]
</tbody>[/TABLE]
I tried to convert the date using formatting, I also tried using len,mid,left right but whatever value I get that's not in standard MM/DD/YYYY format which is recognised by excel in formula/calculation, below is what I tried and I got 21-Jul-11 but unless i do f2+f9 i don't get the required value. after f2+f9 it gets converted to the desired format but there are 10,000+ row of data so I can't do F2+F9 in all the rows.[TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 856"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Find[/TD]
[TD]Day[/TD]
[TD]Month[/TD]
[TD]Year[/TD]
[TD]New Date[/TD]
[/TR]
[TR]
[TD]21 Jul, 11[/TD]
[TD]=FIND(" ",A2,1)[/TD]
[TD]=LEFT(A2,B2-1)[/TD]
[TD]=MID(A2,B2+1,3)[/TD]
[TD]=RIGHT(A2,2)[/TD]
[TD]=C2&"-"&D2&""&"-"&E2[/TD]
[/TR]
</tbody>[/TABLE]

please suggest

 

[Tetra201]

Try using Text to Columns (Delimited --> Delimiters: Tab --> Column data format: Date: MDY)