Wildcard replace any string in context with a specified string

macropod · #5 05-06-2018, 05:49 PM

Quote:

Originally Posted by Guessed

If this is a search and replace activity, you don't NEED to exclude the correct word since you would be replacing it with itself.
Find: EVENING NEWS ???? WALTER
Replace with: EVENING NEWS WITH WALTER

The advantage of using * instead of ???? is that the OCR process may have created more or fewer than 4 characters instead of WITH. The disadvantage, is that is may make false matches (e.g. EVENING NEWS WITHOUT WALTER)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace characters in a string	Anthon	Excel Programming	1	11-03-2016 12:48 AM
How to find all string within string.	PRA007	Word VBA	18	02-12-2016 08:11 PM
Find Multiple Wildcard string and Highlight	PRA007	Word VBA	2	10-17-2015 01:07 AM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM