Hi Team,


I want a macro in MS word that will do the following.



It will first convert the upper case into title case and then replace every
connecting word with lower case.



*Example:*  AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR



*Required Output:*  Agreement. The Adoption the Adult or Married Minor



*Note:* The connecting word “THE” has been replaced by “the” however the
macro left the first connecting word “THE” that followed by dot (.)



Your help would be greatly appreciated.



Thanks,
Sharma

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to