Extracting dates and times written in different formats

[Johnstone200]

Hello,

I am attempting to extract the date and times from a thread of emails which i have extracted from Outlook into Excel. Unfortunatley the dates and times are written in different formats in the original email chain. I have managed to extract the date and time from cells highlighted in red using =IFERROR(DATEVALUE(RIGHT(A2,LEN(A2)-FIND(":",A2)-1))," ")

But all other date/times i am struggling to extract these.

Is there a way of doing this using VBA code (or another formula)?

Thanks in advance.

Matt

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Extracting date/times

Hello, I am lookin to extract dates and times from an extract of customer emials. Unfortunaley as they are extracted they are written in a variety of formats and within different positions of the cell either preceeded or proceeded by other non relevant text. I am struggling to find a formula...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Johnstone200]

Hello,

Same question posted here:

Extracting date/times

Hello, I am lookin to extract dates and times from an extract of customer emials. Unfortunaley as they are extracted they are written in a variety of formats and within different positions of the cell either preceeded or proceeded by other non relevant text. I am struggling to find a formula...

www.excelforum.com

 

[RoryA]

I know, I posted that link for you and I did say there was no need to repeat it.