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:
[TABLE="class: grid, width: 750"]
<tbody>[TR]
[TD]Requisition ID[/TD]
[TD]Requisition Title[/TD]
[TD]Number of Positions[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Talent Advisor[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]XXXXXX00012345[/TD]
[TD]HR Generalist[/TD]
[TD]1[/TD]
[TD]4/24/2017[/TD]
[TD]4/23/2018[/TD]
[TD]Lastname, Firstname[/TD]
[TD]CA-Alameda- Street Address[/TD]
[/TR]
</tbody>[/TABLE]


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.