Breakdown data in cell column

Occasional Visitor

Hello,

 

I have to filter through hundreds of emails a day. In trying to make it an easier process I have exported the emails pertaining to me into an excel spreadsheet. My issue is that I want to split the body of the email. 

(Email Body)

[Formstack Logo]
Formstack Submission For: Floxgen Overall Experience Review<https://-sljal.formstack.com/forms/floxgen__review_form>
Submitted at 01/12/23 8:16 PM
Date/Time: Jan 12, 2023 08:14:33 PM
VenueId: 145
VenueName: 
VendorId: XXXX
VendorName: XXX
SeatId: XXXXX
TableNumber: XXXX
SeatNumber: X
OrderId: XXXXXXXXXXXXXXX
RatingSubmissionId:
XXXXX:: [ XXX ] Newark Liberty Intl, Newark, NJ
Where:: Restaurant
Stars: X
How likely are you to recommend us to a friend or colleague?: X
Rate your Experience:: Food Quality = X
Ordering Process = X
Speed of Service = X
Staff Friendliness = X
Overall Ambiance = X
Cleanliness = X
Checkout Process = X
Would you like to share your name and contact information?: XX
Name:
Phone:
Email:
We'd love to know more about your experience here:: xxxx xxxxxx xx xxxxxxxx


Copyright © 2023 Formstack, LLC. All rights reserved. This is a customer service email.

Formstack, 11671 Lantern Road, Suite 300, Fishers, IN 46038

 

The information I need from the body is (Date, Guest Name, Guest Email, Unit Name)

 

I there a way to make this process less painful?

 

0 Replies