Johnstone200
New Member
- Joined
- Apr 12, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
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
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