Microsoft Office Forums - View Single Post - [Solved] Remove parenthesis that contain four digits or etal word vba

Guessed · 10-29-2023, 10:50 PM

First, do a wildcard search for
\(* [0-9]{4}*\)
Replace with nothing

Then if there are some et al paragraphs left, do another wildcard search
\(*et al*\)
Replace with nothing

You can record these actions to get a first draft of the code that performs it. You can then clean up the code to make it less confusing or just use it as recorded.