Hello smart people! I am total newbie when it comes to VBA and having extra big difficulty in writing up macro for multiple string extraction.
What I have is a long paragraph, which starts with same word – “Start” then I have repeating key words “Middle”, “Remains” and "Analysis".
I need to extract stings between these 4 words into 4 separate columns and making sure that all text after “Remains” to "Analysis" is just extracted but not checked further for key words, and just extract string appearing after "Analysis" without checking for further key words - just go to next line (as text after “Remains” is very long and might include key words – so don’t want it to be checked, same goes for text after "Analysis" key word).
Any help would be much appreciated!
Also please see screen shot for sample data, I use Excel formulas at the moment, but would prefer to have macro for this.... Screen Shot 2013-05-10 at 2.49.30 PM.png
Bookmarks