Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2017, 12:57 PM
macropod's Avatar
macropod macropod is offline Wildcards: searching for multiple words / expressions close to each other Windows 7 64bit Wildcards: searching for multiple words / expressions close to each other Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,523
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 ballpoint View Post
As a follow-up question, is a Word / Office wildcard cheatsheet available somewhere? Most of the documentation I have found was a little fragmented.
See:
https://support.office.com/en-us/art...4-7708c6c779b7
http://www.gmayor.com/replace_using_wildcards.htm
Quote:
Originally Posted by ballpoint View Post
Beyond that, I also wonder if it would not be possible to use something like the Fuzzy Lookup addin (https://www.microsoft.com/en-us/down....aspx?id=15011) for something like this.
I don't know of a fuzzy-match addin for Word. That said, using VBA there are numerous additional matching options available, including:
• IgnorePunct - ignores punctuation in found text


• IgnoreSpace - ignores extra white space in found text
• MatchAllWordForms - (also available via the GUI) finds all forms of the find text, e.g. if the text to find is "sit," "sat" and "sitting" are also found
• MatchPhrase - ignores all white space and control characters between words
• MatchPrefix - matches words starting with the search string
• MatchSoundsLike - (also available via the GUI) matches words that sound similar to the text to find
• MatchSuffix - matches words ending with the search string
• MatchWholeWord - (also available via the GUI) matches only entire words
These don't all work with wildcards and I've rarely needed to call on any of them. YMMV
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 11-09-2017, 03:30 PM
ballpoint ballpoint is offline Wildcards: searching for multiple words / expressions close to each other Windows 10 Wildcards: searching for multiple words / expressions close to each other Office 2016
Advanced Beginner
Wildcards: searching for multiple words / expressions close to each other
 
Join Date: Sep 2017
Posts: 40
ballpoint is on a distinguished road
Default

This is excellent. Thank you so much!
Reply With Quote
Reply

Tags
multiple, wildcards



Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcards: searching for multiple words / expressions close to each other Regular Expressions / Wildcards: [1990] --> (1990) tinfanide Word 2 08-10-2015 02:34 PM
Wildcards: searching for multiple words / expressions close to each other Searching for words across all file formats sunalta Windows 2 01-22-2014 08:00 AM
Wildcards: searching for multiple words / expressions close to each other Regular Expressions: match words within quotes? tinfanide Word VBA 3 02-02-2013 10:07 PM
Wildcards: searching for multiple words / expressions close to each other Searching Multiple PowerPoint & Word Files BobbyAre PowerPoint 14 08-12-2012 06:52 AM
Wildcards: searching for multiple words / expressions close to each other searching for text in multiple excel files roytom Excel 2 07-30-2012 01:57 PM

Other Forums: Access Forums

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