Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2018, 10:37 AM
puff puff is offline Replace multiple strings by one same string at once Windows 7 64bit Replace multiple strings by one same string at once Office 2013
Advanced Beginner
Replace multiple strings by one same string at once
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question Replace multiple strings by one same string at once

Hi all. I want to replace all the "[A-Z]." and "table" into "cup" at once, for example. Is that possible to do this by using the wildcard once by somehow combining these 2 standards together? I tried "[[A-Z]. table]" but it doesn't work. Thanks~
Reply With Quote
  #2  
Old 02-28-2018, 12:04 AM
macropod's Avatar
macropod macropod is offline Replace multiple strings by one same string at once Windows 7 64bit Replace multiple strings by one same string at once 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

The "[A-Z]." looks like a wildcard expression that would match all capitals followed by a period. Is that what it's supposed to be, or is it literal text? In any event, you can't combine both expressions into a single Find/Replace.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-28-2018, 11:04 AM
puff puff is offline Replace multiple strings by one same string at once Windows 7 64bit Replace multiple strings by one same string at once Office 2013
Advanced Beginner
Replace multiple strings by one same string at once
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Default

Yeah. Now I know that. I simply combined the 2 replacing process in a macro.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do multiple find and replace in string. PRA007 Word VBA 2 01-06-2016 09:10 PM
Replace multiple strings by one same string at once Search Multiple strings and create new word file subodhgupta Word 4 05-22-2014 03:34 AM
Replace multiple strings by one same string at once Search Multiple strings and create new word sheet subodhgupta Word Tables 1 05-20-2014 08:09 AM
Find and replace inside strings containing various names audioman Word VBA 4 03-25-2014 11:19 AM
Replace multiple strings by one same string at once Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 PM.


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