Thread: Delete text
View Single Post
 
Old 12-31-2010, 06:00 PM
Michael007 Michael007 is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Dec 2010
Posts: 18
Michael007 is on a distinguished road
Default Text delete

Hi Paul,

I have access to thousands of marine forecasts in archive. My job is to verify the winds forecast only. Besides that, I don't really care about the weather. This is why, I want a macro to get rid of the weather section and to reduce the number of pages to read.

My next step will be to replace several redundant words (like: morning, afternoon, evening, becoming,.. by abbreviations like AM, PM, Evng, bcmg...) all that in order to fit every forecast within a page (actually a single forecast takes 2-3 pages).

Michael

PS: I tried your command in a macro (Find = Periods[!.]{1,}.
Replace = nothing) but the line "Find... appeared in red. I guess that I missed something... as I said in just beginning in VBA
Reply With Quote