Word macro to find and replace % to percent conditionally

Hello, I would like to get some assistance in writing a find and replace Word 2007 macro from the folks here. I would like the macro to perform two conditional operations.

First, for any text that is not enclosed by ( ) or [ ] find the % sign and change it to the word 'percent' without the single quotes.

Next, find any instances of percent enclosed by ( ) or [ ] and change this to the % symbol.

Any help would be greatly appreciated as always.

Thanks,
Bev

BevosAsked: 2012-04-12

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 77

GrahamSkanRetiredCommented: 2012-04-12

Can you clarify, please?

"for any text that is not enclosed by ( ) or [ ] ". 'Any text' is a bit vague. It could be a whole document, a paragraph, a word, one character or anything in between.

For that which is already enclosed, what needs to be changed to a % symbol?

Perhaps a few examples would help.

BevosAuthor Commented: 2012-04-12

Hi Graham, thanks so much for the response here is an example:

When I said any text I mean that the whole word document would be scanned for these changes. Sorry if there was confusion by the vague wording.

Before correction:
This is an example paragraph in which % is used incorrectly. However if someone uses parentheses then (percent) should use a symbol instead. This should be the case even if large amounts of text are in parentheses. [This example of percent should be informative %]. So basically percent is spelled out whenever not enclosed by parentheses or brackets.

After correction:
This is an example paragraph in which percent is used incorrectly. However if someone uses parentheses then (%) should use a symbol instead. This should be the case even if large amounts of text are in parentheses. [This example of % should be informative %]. So basically percent is spelled out whenever not enclosed by parentheses or brackets.

LVL 77

GrahamSkanRetiredCommented: 2012-04-12

Sorry for the delay. It was quite difficult to find text that is not in brackets. Hopefully you aren't already using highlighting because this code uses temporary highlighting to differentiate.

Sub Percent()
    Dim rng1 As Range
    
    Set rng1 = ActiveDocument.Range
    Application.Options.DefaultHighlightColorIndex = wdYellow
    With rng1.Find
        .MatchWildcards = True
        .Text = "\(*\)"
        .Replacement.Highlight = True
        .Execute Replace:=wdReplaceAll
        
        .Text = "\[*\]"
        .Replacement.Highlight = True
        .Execute Replace:=wdReplaceAll
        
        .MatchWildcards = False
        .Text = "percent"
        .Highlight = True
        .Replacement.Text = "%"
        .Execute Replace:=wdReplaceAll
        
        .Text = "%"
        .Highlight = False
        .Replacement.Text = "percent"
        .Execute Replace:=wdReplaceAll
        
    End With
    ActiveDocument.Range.HighlightColorIndex = wdNoHighlight
End Sub

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial