Extracting Data From String in Exported Emails

[Th3Hovster]

Hello,

Thank you in advance for taking time to review my question.

I have a list of emails exported from Outlook to a .CSV file and I am trying to extract data from the "Body" cell and paste it into corresponding cells on a different sheet.

Each email contains somewhere in the body this information:Details
Job Requisition ID: XXXXXX00012345
Job Requisition Title: HR Generalist
Job Requisition Number of Positions: 1
Job Requisition Start Date: 04/24/2017
Job Requisition End Date: 04/23/2018
Talent Advisor: * Lastname, Firstname (Lastname.Firstname@email.com)
Location: CA-Alameda-Street Address-2001800000

I need the data after each colon and would like it to be pasted into a column named similarly to what's before each colon.
Example:

Requisition ID	Requisition Title	Number of Positions	Start Date	End Date	Talent Advisor	Location
XXXXXX00012345	HR Generalist	1	4/24/2017	4/23/2018	Lastname, Firstname	CA-Alameda- Street Address

<tbody>
</tbody>

I'm wondering if there is a macro or anything other than the MID, FIND function since the data isn't always the same character length from email to email.

Thanks again.