Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-16-2011, 09:13 PM
Michael007 Michael007 is offline keep only sentences beginning with: Wind Windows 7 64bit keep only sentences beginning with: Wind Office 2003
Novice
keep only sentences beginning with: Wind
 
Join Date: Dec 2010
Posts: 18
Michael007 is on a distinguished road
Default keep only sentences beginning with: Wind

Hi everyone,

I am a beginner with VBA. I wonder if it is possible with a VBA to keep in a long text, only the sentences beginning with the words: "Wind" or "Donaway" or "Sagway". If yes, could you write a piece of VBA, pls.

For instance, in the following text:
=====
Donaway to Isle-Icer - eastern half.
Winds southwest 15 to 25 knots diminishing to light this evening. Wind increasing to northeast 20 to 30 near noon saturday. Periods of drizzle and occasional fog turning to snow tonight. Low tonight minus 1. High Saturday plus 2.

Sagway to Tadouvik.
Gale warning in effect.
Wind light becoming east 10 to 15 knots early this evening then diminishing to light near midnight.Wind increasing to east 15 to 25 near noon Saturday and to 25 to 35 Saturday evening. Risk of freezing drizzle late this afternoon.
====

I wish to keep only
====


Donaway to Isle-Icer - eastern half.
Wind southwest 15 to 25 knots diminishing to light early this evening and to light near midnight. Wind increasing to northeast 15 to 25 near noon Saturday.

Sagway to Tadouvik.
Wind light becoming east 10 to 15 knots early this evening thendiminishing to light near midnight. Wind increasing to east 15 to25 near noon Saturday and to 25 to 35 Saturday evening.
=========


Thanks for your help
Michael
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sentences and paragraphs keep disappearing in Word XP (2002) at bottom of page urobolus Word 3 08-26-2011 10:02 AM
Dash in the beginning of a new line Wakinyan Word 0 07-11-2010 07:10 AM
keep only sentences beginning with: Wind Add text to the beginning/ending of each line in word ballmoney Word 1 01-17-2010 02:19 AM
Looping macros to add text to beginning and end of a paragraph pachmarhi Word VBA 0 02-16-2009 06:57 AM
capitalize first letter of sentences norco1 Word 0 06-25-2006 12:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft