Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-13-2012, 01:08 PM
Rabski Rabski is offline Odd search and replace query Windows 7 64bit Odd search and replace query Office 2010 64bit
Novice
Odd search and replace query
 
Join Date: Nov 2012
Posts: 1
Rabski is on a distinguished road
Default Odd search and replace query

Hi guys and girls.



I have an odd thing I need to do.

Basically I have a massive text where the author has used 'quote 1' 'quote 2' 'quote 3' etc. The publisher needs "quote 1" "quote 2" etc, etc.

I can find everything with '*' and wildcard enables. However, I can't replace with "*", as that is what it gets replaced with, i.e. "*".

In other words, I need to replace a caharcter at the beginning and end, but leave the text inbetween unchanged, said text being different each time.

I've tried various \ escape strings in the replace, but it always either falls over or messes up.

Anyone know?

I'm sure it's possible!

Last edited by macropod; 11-13-2012 at 02:11 PM. Reason: Inapproriate expression deleted.
Reply With Quote
  #2  
Old 11-13-2012, 02:25 PM
macropod's Avatar
macropod macropod is offline Odd search and replace query Windows 7 64bit Odd search and replace query 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

A Find/Replace can be used, but you'll need to do it interactively so as to not confuse single closing quotes and apostrophes:
Find = '
Replace = "
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IE automation: How to auto-click the first link on the search query page? tinfanide Excel Programming 0 05-30-2012 11:02 PM
Odd search and replace query Word Find and Replace Query bthart Word 1 12-29-2011 12:45 AM
Odd search and replace query Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM
Search Replace Copy dblack7211 Word 0 05-05-2010 01:19 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

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