How to convert imported US to UK

[imy1971]

HI All

I need some urgent answers please. I would would like to convert an imported date (US) to a UK version

ie Apr, 13, 2011 to 13/04/2011. i have an excel 2010 version. I tried to use text column it does not work unless I am doing it wrong

Let me know urgently what the formula is

thanks guys

Imy

 

[VoG]

Try

=DATEVALUE(MID(A1,6,2)&"-"&LEFT(A1,3)&"-"&RIGHT(A1,4))

and format as Date.

 

[imy1971]

Thanks VoG

Sorry the format of the imported date is as below, not the US format above

Cheers

Imy
<table style="width: 143px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col width="77"><tr height="34"> <td class="xl65" style="height: 25.5pt; width: 58pt;" width="77" height="34">Apr 13, 2011
</td> </tr></table>

 

[VoG]

Try

=DATEVALUE(MID(A1,5,2)&"-"&LEFT(A1,3)&"-"&RIGHT(A1,4))

 

[imy1971]

Peter I salute you thank you so much made my day

 

[imy1971]

<table style="width: 293px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col width="120"><tr height="34"> <td class="xl66" style="height: 25.5pt; width: 90pt;" width="120" height="34">hi Peter if your around I am looking at removing the brackets Apr 2011 (Apr 1-Apr 30) and the format will be mmm-yy( Jan-11)

What will be the formula

Thank you

Imy


</td> </tr></table>

 

[VoG]

Sorry it isn't clear what you have. Please copy directly from the cell and paste in a reply together with your expected result.

 

[imy1971]

<table style="width: 287px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col width="120"><tr height="34"> <td class="xl66" style="height: 25.5pt; width: 90pt;" width="120" align="left" height="34">I would like to convert imported date format from

Apr 2011(Apr 1-Apr 30)

convert to Apr-11

Hope that helps

Cheers

Imran
</td> </tr></table>

 

[VoG]

Try

=DATEVALUE("1-"&LEFT(A1,3)&"-"&MID(A1,5,4))

and format as Custom mmm-yyyy

 

[imy1971]

HI Peter thank you once again

I am trying to use find function to identify a model no in a url string. What I do know is constant is the product model after download.tmp/c-class see below in red. I would like to identify the product model using a formula in another cell. The output be 'C-Class'

download.tmp/C-Class%20Pricelist%20January%202011.pdf

Cheers

Imran