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