Date Value from my Text String

The doomed

Active Member
Joined
Feb 13, 2008
Messages
263
I have the following outputs into a column:

Fri, 29 Aug 2014 10:57:16 Europe/London
Thu, 04 Sep 2014 10:15:19 Europe/London
Thu, 04 Sep 2014 11:06:15 Europe/London
Thu, 04 Sep 2014 11:19:19 Europe/London
Thu, 04 Sep 2014 12:07:57 Europe/London
Thu, 04 Sep 2014 13:45:39 Europe/London

I want to turn each into a date DD-MM-YYYY

Can someone steer me in the right direction please?

<colgroup><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
This works

=SUBSTITUTE(MID(A1,6,11)," ","-")+0
and copy down

format cells as dates of course
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

=DATEVALUE(MID(A1,6,2)&"/"&MID(A1,9,3)&"/"&MID(A1,13,4))

Format as Date.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,816
Messages
5,525,061
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top