Retrieving various date formats

pottyarchy

New Member
Joined
Nov 17, 2011
Messages
2
I am trying to find dates & time within text in a cell & return to a separate cell. The issue I have is that the date format varies frequently. I also can't rely on searching for "Sent:" as this also varies frequently

e.g. From: ########
Sent: 17 November 2011 11:57

I would like to return 17/11/2011 11:57

From: #######
Sent: 01/11/2011 11:50:13

I would like to return 01/11/2011 11:50

From: ########
Date: 05/11/2011 09:45:13

How can i search for various forms of dates and return them into a cell?

assistance would be greatly appreciated :confused:
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

pottyarchy

New Member
Joined
Nov 17, 2011
Messages
2
Thanks matey. my problem is the workbook is trying to calculate email response times, so one column is filled in with all of the emails received [Email header, subject, timestamp and text body] whilst another column includes the reply email. This means i have to search for the date and timestamp within the text on one cell and try and retrieve this into a separate column.

The challenge is that the format this comes through in changes depending on the email format the sender users. (otherwise i could just search for "/" etc..

Any ideas would be greatly appreciated.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,115
Messages
5,466,769
Members
406,498
Latest member
ddreadedd

This Week's Hot Topics

Top