Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2014, 07:06 PM
Robert2 Robert2 is offline Need YOUR help! With Find and Replace! Windows 8 Need YOUR help! With Find and Replace! Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 174
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

Simply set up the Find dialog with this wildcard search:

Find What:
[A-Z ]{1,}:


Choose "Highlight All".

When all the instances are highlighted (i.e. selected), On the Home tab, in the Font group, click Change Case, then choose "Capitalize Each Word".
Reply With Quote
  #2  
Old 05-28-2014, 07:22 PM
ctsolar ctsolar is offline Need YOUR help! With Find and Replace! Windows 8 Need YOUR help! With Find and Replace! Office 2013
Novice
Need YOUR help! With Find and Replace!
 
Join Date: Dec 2013
Posts: 6
ctsolar is on a distinguished road
Smile Whaaaaaaaat?!

Wow! Thank you!! Thank you so much! I don't know who you are but you have saved me (liteally) dozens of hours of time!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Find and Replace Loop Tango Mike Word 3 04-20-2014 02:47 PM
Need YOUR help! With Find and Replace! Find, Replace Ajay Shahane Word VBA 4 05-16-2012 04:07 AM
Need YOUR help! With Find and Replace! Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Need YOUR help! With Find and Replace! Is there a way to use "find/replace" to find italics words? slayda Word 3 09-14-2011 02:16 PM
Need YOUR help! With Find and Replace! Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:36 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