Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2012, 07:56 AM
Bobosmite Bobosmite is offline Is there a way to find CAPITALIZED words in a doc? Windows 7 Is there a way to find CAPITALIZED words in a doc? Office 2003
Advanced Beginner
Is there a way to find CAPITALIZED words in a doc?
 
Join Date: May 2010
Posts: 47
Bobosmite is on a distinguished road
Default Is there a way to find CAPITALIZED words in a doc?


I want to turn CAPITALIZED words into proper SMALL CAPS. Is there a script or macro that can search a doc for words that have all capital letters and are not tagged "all caps"?
Reply With Quote
  #2  
Old 03-15-2012, 03:06 PM
macropod's Avatar
macropod macropod is online now Is there a way to find CAPITALIZED words in a doc? Windows 7 64bit Is there a way to find CAPITALIZED words in a doc? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Bobsomite,

You can use a wildcard Find/Replace, where:
Find = <[A-Z][a-z]@>
Replace = ^&
and the Find font format has the 'All Caps' option unchecked and the Replace font format has the 'Small Caps' option checked.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-15-2012, 04:14 PM
Bobosmite Bobosmite is offline Is there a way to find CAPITALIZED words in a doc? Windows 7 Is there a way to find CAPITALIZED words in a doc? Office 2003
Advanced Beginner
Is there a way to find CAPITALIZED words in a doc?
 
Join Date: May 2010
Posts: 47
Bobosmite is on a distinguished road
Default

That is the best damn thing I've learned all week. Eventually I got around to digging into the Microsoft Help, but what really helps is seeing your syntax. After a little tinkering with it, I was able to pare it down to words 3 letters or greater. Very cool, thanks again!
Reply With Quote
  #4  
Old 03-15-2012, 04:19 PM
macropod's Avatar
macropod macropod is online now Is there a way to find CAPITALIZED words in a doc? Windows 7 64bit Is there a way to find CAPITALIZED words in a doc? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Bobosmite View Post
After a little tinkering with it, I was able to pare it down to words 3 letters or greater.
For that you could use:
Find = <[A-Z][a-z]{2,}>
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 07-21-2013, 07:58 PM
Styler001 Styler001 is offline Is there a way to find CAPITALIZED words in a doc? Windows Vista Is there a way to find CAPITALIZED words in a doc? Office 2007
Novice
 
Join Date: Jan 2009
Posts: 4
Styler001 is on a distinguished road
Default

Wow!

You just saved me a couple of hours.

Thank you!!!!


Reply With Quote
  #6  
Old 01-28-2014, 09:41 AM
AlanSowell AlanSowell is offline Is there a way to find CAPITALIZED words in a doc? Windows 7 32bit Is there a way to find CAPITALIZED words in a doc? Office 2010 32bit
Novice
 
Join Date: Jan 2014
Posts: 1
AlanSowell is on a distinguished road
Question Wow

Where can I learn more about the find wildcard feature? Specifically the coding like: <[A-Z][a-z]@>
Reply With Quote
  #7  
Old 01-28-2014, 01:42 PM
ChrisBrewster ChrisBrewster is offline Is there a way to find CAPITALIZED words in a doc? Windows 7 64bit Is there a way to find CAPITALIZED words in a doc? Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2014
Posts: 36
ChrisBrewster is on a distinguished road
Default

Word wildcards are at this URL:

http://office.microsoft.com/en-us/wo...005189433.aspx

Don't forget to click the More button and check 'use wildcards' .

Below is the string I use to find acronyms. It also finds acronyms that include digits-- the problem being that it also stops on plain old numbers. See if it does you any good.

[ETAOINSRHDLUCMFYWGPBVKXQJZ1234567890_-]{2,}
Reply With Quote
  #8  
Old 01-28-2014, 02:49 PM
macropod's Avatar
macropod macropod is online now Is there a way to find CAPITALIZED words in a doc? Windows 7 32bit Is there a way to find CAPITALIZED words in a doc? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by ChrisBrewster View Post
Below is the string I use to find acronyms. It also finds acronyms that include digits-- the problem being that it also stops on plain old numbers. See if it does you any good.

[ETAOINSRHDLUCMFYWGPBVKXQJZ1234567890_-]{2,}
You should be able to achieve the same with:
[A-Z0-9_-]{2,}
or, if your acronyms always start with a letter:
[A-Z][A-Z0-9_-]{1,}
As for the numbers issue, if you mean it doesn't find complete numbers with thousands separators & decimal points, that's because neither of those is provided for in your Find expression. Problem is, though, that if you do so, it'll also pick up commas and periods.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 01-28-2014, 03:53 PM
ChrisBrewster ChrisBrewster is offline Is there a way to find CAPITALIZED words in a doc? Windows 7 64bit Is there a way to find CAPITALIZED words in a doc? Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2014
Posts: 36
ChrisBrewster is on a distinguished road
Default

Thanks. I got in the habit of putting the letters in order of frequency, in earlier times when computer speed was an issue. Yours is nice and compact. I added "\." to the beginning of the search string and now it finds things like D4S-1.3.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to find CAPITALIZED words in a doc? Find and highlight multiple words in MS Word document AtaLoss Word VBA 37 09-22-2021 12:04 PM
Can you check the "find whole words only" box when using characters? pimpong Word 6 02-06-2012 06:56 PM
Is there a way to find CAPITALIZED words in a doc? Is there a way to use "find/replace" to find italics words? slayda Word 3 09-14-2011 02:16 PM
Is there a way to find CAPITALIZED words in a doc? Find & Replace words with "/" prefix & suffix tollanarama Word 4 01-25-2011 02:19 AM
FInd recurring words in Word 2003 NJ007 Word 4 01-25-2010 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 AM.


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