troubleshooting Question
Parse email body text into Excel cells
asked on
Looking for VBA Code to Parse Variable Length List into a Table
The text (from the Body of an email) looks like this... I want to extract that into individual cells in Excel
PALLET ID LABEL CREATION TIME NET WEIGHT
--------------------------
125640400926 15-AUG-18 20:33:34.0 1091
125640400933 15-AUG-18 22:23:34.0 1091
125640400938 16-AUG-18 00:19:51.0 1091
125640400944 16-AUG-18 01:29:01.0 1091
125640400951 16-AUG-18 03:35:05.0 1091
125640400956 16-AUG-18 04:37:27.0 1091
125640400961 16-AUG-18 05:50:58.0 1091
125640400972 16-AUG-18 08:05:38.0 1091
The text (from the Body of an email) looks like this... I want to extract that into individual cells in Excel
PALLET ID LABEL CREATION TIME NET WEIGHT
--------------------------
125640400926 15-AUG-18 20:33:34.0 1091
125640400933 15-AUG-18 22:23:34.0 1091
125640400938 16-AUG-18 00:19:51.0 1091
125640400944 16-AUG-18 01:29:01.0 1091
125640400951 16-AUG-18 03:35:05.0 1091
125640400956 16-AUG-18 04:37:27.0 1091
125640400961 16-AUG-18 05:50:58.0 1091
125640400972 16-AUG-18 08:05:38.0 1091
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.