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:
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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,129,383
Messages
5,635,951
Members
416,889
Latest member
dhegs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top