Conversion of dates/times

[DesCall]

Hello Forum,

I have a long column of dates/times, each in the following text format:
Thu Nov 24 19:07:01 GMT+00:00 2011

I wish to create a new column that provides each in the following text format:
24/11/2011 19:07

Can someone help with an appropriate method/formula please?

Many thanks,
Des

[TMS]

Assuming every cell has the same format, I would use MID to extract the year, month, day, hours and minutes and DATE + TIME to get the date/time in a cell and then format it as required.

Regards, TMS

[zbor]

Something like this:

Only question is how would you write 1.11.2011:

Thu Nov 1 19:07:01 GMT+00:00 2011
Thu Nov 01 19:07:01 GMT+00:00 2011

Solution will work for 2nd one.

[Cutter]

Possibly

=TEXT(DATEVALUE(TRIM(MID(A2,5,6))&", "&RIGHT(A2,4)),"dd/mm/yyyy")&" "&TEXT(TIMEVALUE(TRIM(MID(A2,11,9))),"hh:mm")

should work for either way

[daddylonglegs]

That doesn't seem to work with UK regional settings, Cutter - I suggest this formula

=REPLACE(MID(A2,9,11),3,0,"-"&MID(A2,5,3)&"-"&RIGHT(A2,4)&" ")+0

that works with UK or US regional settings and should also work with 02 Nov or 2 Nov

format result cell any way you want, in your case dd/mm/yyyy hh:mm