Need Macros

  • Thread starter Thread starter Prasant
  • Start date Start date
P

Prasant

Hi there,
I need a macro which should perform the following tasks for the working file.
1. Search for double spaces after period and replace with single space.
2. Search for three spaces and replace with single space.
3. Search for space before and after " / " (slash) and replace with no
spaces "/"
4. Search for space before slash " /" and replace with no space like this "/"
5. Search for space after slash "/ " and replace with no space like this "/"
6. Search for two hyphens "--" and replace with "–" (endash)
These all should perform in one single click button in the working file. Can
anyone please give the code to create a macro for the above mentioned points.
MANY THANKS IN ADVANCE. Your help is appreciated.
 
While a macro to do this wouldn't be all that hard to write, you could
do all this yourself with search and replace. If you need to do this a
lot, I think that recording a macro before you start the first time
should work. For many things that people want to do, recording a macro
is a bad idea, but I think it is the perfect solution for this.
--David
 
I agree with David, but would also note that problem one and two can be
solved with the same search and replace function. ie replace " "(two spaces)
with " "(one space. Simply run this search and replace until it tells you it
could not find any instances.
 
The code for this would actually be quite complex and I don't think that the
recorder will help much (though by all means try it)

Unfortunately I don't have an "off the shelf" answer I can post here, maybe
someone else has which would be a good solution.

If you are stuck we can certainly write a macro for you if you get in touch.
This wouldn't be free though but it would be easily adapted if you need to
add further search and replace items.
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk
 
Back
Top