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

=MID(A1,FIND("/",A1)+1,FIND("%",A1)-FIND("/",A1)-1)

 

[VoG]

In response to your PM try

=MID(A1,FIND("/",SUBSTITUTE(A1,"//","~~"))+1,FIND("!",SUBSTITUTE(A1,"_","!",1))-FIND("/",SUBSTITUTE(A1,"//","~~"))-1)

 

[imy1971]

Thank you but that came up as 'content media' which is at the start of the url not the model name in red shown in earlier PM

 

[VoG]

The string that you provided didn't contain the text content media.

 

[VoG]

In response to further PM

B1=RIGHT(A1,LEN(A1)-FIND(".tmp/",A1)-4)
C1=LEFT(B1,FIND("_",B1)-1)

 

[imy1971]

HI

I am trying to change dd/mm/yyyy to '201104' (year and month)

Any help please

Thanks
Imy

 

[VoG]

Try

=TEXT(A1,"yyyymm")

 

[imy1971]

Thank you Peter :0)

Another question I am looking to automate a process where I can update the csv file (ftpsite) from an excel spreadsheet in a share drive . Is there any way this can be automated without manually copy and paste . Can you use indirect function not sure if that is possible

chEERS

Imran

 

[VoG]

Now you have gone way off topic. Please start a new thread for this completely different question.