Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2018, 09:49 AM
markus674 markus674 is offline Find/Replace Help Windows 7 32bit Find/Replace Help Office 2007
Novice
Find/Replace Help
 
Join Date: Mar 2018
Posts: 1
markus674 is on a distinguished road
Default Find/Replace Help

Hi All,



I'm trying to figure out if I can use find/replace in a specific way to help me with something. I've looked up info on wildcards but I can't seem to find anything that would work in this instance. Any advice?

I want to find all instances of a word which does NOT follow another specific word. In this case I want to find all instances of the name of an organisation (CSN) where it is NOT followed by "the", so I can then add "the" to all instances. Can I use find/replace to do this?

Any help would be greatly appreciated!
Reply With Quote
  #2  
Old 03-20-2018, 03:49 PM
slaycock slaycock is offline Find/Replace Help Windows 7 64bit Find/Replace Help Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

You can do this in two steps without wildcards

1. replace 'CSN' with 'CSN the'
2. replace 'the the' with 'the'


If you want to use a wildcard search

replace '(CSN)(![t])(![h])(![e])( )' with '/1 the' you'll need to look up the exact wildcard syntax.
Reply With Quote
Reply

Tags
find & replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
In Find and Replace, can Word stop after each Replace? wardw Word 1 06-08-2017 02:47 PM
Find/Replace Help VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File QA_Compliance_Advisor Word VBA 11 09-11-2014 11:51 PM
Find/Replace Help Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
Find/Replace Help Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Find/Replace Help 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 08:28 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