troubleshooting Question

Create a macro to compile data in multiple .txt files into one .xls file - Part 2 (extraction)

Avatar of ceneiqe
ceneiqeFlag for Australia asked on
Microsoft Excel
4 Comments1 Solution533 ViewsLast Modified:
This question is related to
https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27256398.html

[Reason: I have already allocated the points to what has been requested and this is a follow up-add-ons to what i initially requested.]


To extract the following text line that starts with "Z" and add this as a comment at the end of the column.

For example,  see attached.
Example-10.03.11--more-than-1--A.txt

Result: This text should be placed in the final column.
 Example-2.7.10--1--Add-ons-.xls

There will always be a comment.
The comment is in text format. Usually starts with "Z" else, can be any alphabet.
The text length can vary but will always be in 1 line.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
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 4 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.

-Mike Kapnisakis, Warner Bros