View Single Post
 
Old 01-17-2011, 03:15 PM
Michael007 Michael007 is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Dec 2010
Posts: 18
Michael007 is on a distinguished road
Default Keep only sentences beginning with: wind

Hi Paul,

it is very close but there are still a few details to fix.
1. The VBA keeps only the text of the current line (until the next paragraph and the rest of the sentence is lost). Infact, I want to keep the text until the next "." .
2. It keeps the blank lines from one region to the other. How can I get rid of them.

I joined an example of a marine forecast. I did make the appropriate changes "Wind,Northerly,Southerly,Easterly,Westerly"

Thanks for your help
Michael
Attached Files
File Type: doc Marine4.doc (37.5 KB, 12 views)
Reply With Quote