Hello,



This one looks a bit tricky but hope any of you guys know how to do it!

I need a Macro to make a multiple search of different types of spaces which appears along to numbers or symbols.

The idea is that the Macro FIND some specific types of spaces and THEN replace them with non-breaking spaces.

When the Macro finds such spaces, I will decide if the space can be replaced by a non-breaking space or not. So, the Macro should prompt and ask if the space can be replaced by a non-breaking space and then continuing with the rest of instances.

Basically, the Macro will search the following spaces:

NOTE: I have put an asterisk "*" in order to make visible the space

- All numbers following a space: [0‐9]*
- Equal sign and space: =*
- Space and equal sign: *=
- Bracket followed by space: [0‐9]\)

Would that be possible?

Thanks in advance!

If you want to do this interactively as your post suggests, there hardly seems to be any point to using a macro.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for letting me know. I assumed that macros may contain interactive content but can see that this is not possible.

So, if we discard the interactive element, can we simply create a macro that finds the spaces mentioned in my post? That is:

- numbers following a space: [0‐9]*
- Equal sign and space: =*
- Space and equal sign: *=
- Bracket followed by space: [0‐9]\)

Once the macro finds any of these spaces, I will substitute them with non-breaking spaces, if I consider that they are applicable.

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.
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?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

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 =.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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?

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]