Macro to find and replace specific types of spaces

macropod · #1 04-30-2018, 02:41 PM

Quote:

Originally Posted by dita

I assumed that macros may contain interactive content but can see that this is not possible.

They can contain interactive content but, for what you described, that makes such a macro fairly pointless, since it's going to have to pause at each match and wait for user input, just as it would when using Find/Replace.

Quote:

Originally Posted by dita

So, if we discard the interactive element, can we simply create a macro that finds the spaces mentioned in my post?
...
Once the macro finds any of these spaces, I will substitute them with non-breaking spaces, if I consider that they are applicable.

Maybe I'm missing something here - you first asked whether a macro could supply the non-breaking spaces interactively. How is your re-worded requirement any different in that regard?

Pintus · #2 05-05-2018, 03:27 AM

Quote:

Originally Posted by macropod

They can contain interactive content but, for what you described, that makes such a macro fairly pointless, since it's going to have to pause at each match and wait for user input, just as it would when using Find/Replace.

Yes, I don´t mind if the macro do a pause at each match and wait for my input. The reason why I want to do this with a macro is because searching with Wildcards only allows to find one item per Find/Replace. So, using a macro, we could find different type of spaces in one go.

Maybe I'm missing something here - you first asked whether a macro could supply the non-breaking spaces interactively. How is your re-worded requirement any different in that regard?

If the macro can do the search interactively that would be best option but I´m not sure if this possible or not.

macropod · #3 05-05-2018, 03:56 AM

Quote:

Originally Posted by Pintus

searching with Wildcards only allows to find one item per Find/Replace

Not so. For example,
Find = [0‐9=\) ^s][ ^s=]
will find any of:
• 0‐9
• =
• )
• a normal space or a non-breaking space
followed by a normal space, a non-breaking space, or a =.

Pintus · #4 05-05-2018, 08:36 AM

Very interesting....

So, what´s the way to add more than one search in the wildcards?

Just separating what I want to find in brackets?

macropod · #5 05-06-2018, 12:47 AM

Quote:

Originally Posted by Pintus

So, what´s the way to add more than one search in the wildcards?

Just separating what I want to find in brackets?

No, it's just a single search that finds all the possibilities you listed - it may also make what you might regard as false matches. You'd need to test it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace/Insert 'CR', delete leading Spaces wherever a user Clicks in a Word document	DavidL	Word VBA	7	04-04-2018 12:01 AM
Find and Replace Macro Need	djpemberton	Word VBA	2	05-04-2016 07:53 PM
Find and replace mutiple spaces between lowercase words only	Dave T	Word VBA	2	07-16-2015 11:23 PM
Find and Replace Macro	amparete13	PowerPoint	3	03-11-2014 05:29 AM
Macro to replace one specific heading style with another	ubns	Word VBA	44	09-04-2012 08:17 PM