To my favorite experts - I need to enlist your assistance once again:
I need to put together a timeline from the headers of email. I am copying and pasting the header into a cell.
Is there any way to extract the information from line 2below? In this case, it would be returning: Sent: Wednesday, October 29, 2014 8:43 AM
Note: this data is all in one cell.
"From: Souder, Dianne
Sent: Wednesday, October 29, 2014 8:43 AM
To: Last Name, George
Subject: FW: SOW for CompanyX 4.1 upgrade - need entry and into process for approval & legal review
Importance: High"
Thank you in advance for looking.
Bookmarks