Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2017, 01:22 PM
cheech1981 cheech1981 is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 64bit
Advanced Beginner
search for consecutive words beginning with capital letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default search for consecutive words beginning with capital letter

Hi all,



Is there a way to search for two consecutive words that are set in title case (i.e., first letter is capitalized and remaining letters are lowercase)?

I know [A-Z] will find a capital letter, but not sure how to define two strings beginning with a capital letter.
Reply With Quote
  #2  
Old 11-22-2017, 01:25 PM
cheech1981 cheech1981 is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 64bit
Advanced Beginner
search for consecutive words beginning with capital letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

I should say that my current attempt is

[A-Z][a-z] [A-Z][a-z]

But it only seems to be finding word pairs that start after a punctuation mark.
Reply With Quote
  #3  
Old 11-22-2017, 02:27 PM
macropod's Avatar
macropod macropod is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

Provided both words have more than one letter, a wildcard Find with:
Find = <[A-Z][! ]@ [A-Z][! ]@>
should do.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 11-22-2017, 03:50 PM
cheech1981 cheech1981 is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 64bit
Advanced Beginner
search for consecutive words beginning with capital letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

That's great Paul, thanks. Would it also be possible to look for the same thing, but with a space after the second word? (this would help me reduce the found instances and focus on what I'm looking for).

I tried adding the space after the second @ but it did not seem to register.
Reply With Quote
  #5  
Old 11-22-2017, 03:53 PM
macropod's Avatar
macropod macropod is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

Simply add a space character after the >
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 11-22-2017, 04:08 PM
cheech1981 cheech1981 is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 64bit
Advanced Beginner
search for consecutive words beginning with capital letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

Great, thanks so much Paul and happy holidays!
Reply With Quote
  #7  
Old 11-22-2017, 04:47 PM
macropod's Avatar
macropod macropod is offline search for consecutive words beginning with capital letter Windows 7 64bit search for consecutive words beginning with capital letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

I don't get holidays - I'm retired...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 11-24-2017, 12:50 PM
cheech1981 cheech1981 is offline search for consecutive words beginning with capital letter Windows 10 search for consecutive words beginning with capital letter Office 2016
Advanced Beginner
search for consecutive words beginning with capital letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

Sounds good!
Reply With Quote
Reply

Tags
search, title case



Similar Threads
Thread Thread Starter Forum Replies Last Post
MS word 2007, capital letter after number (1. place turn to 1. Place) enzo321 Word 1 10-23-2016 06:19 AM
search for consecutive words beginning with capital letter How to keep a word with capitalized first letter, but not at the beginning of a sentence? xiangwulu Word 4 10-31-2014 09:00 AM
How to Turn Off Message "Search from the beginning of a document" in a Macro sleake Word 10 10-15-2013 03:43 PM
search for consecutive words beginning with capital letter Converts the words to actual All Capital Letters not workin macro?? powerdrum Word VBA 2 12-08-2011 05:06 PM
search for consecutive words beginning with capital letter Why did I get the Capital Letter automatically after I press the "Space Bar"? LUCK_TOUCH Word 2 08-15-2011 09:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:20 PM.


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