For a moment, there, Paul, you had me really excited. I'd never seen the wildcard find and replace function before, so I thought I was learning something new. Then I tried it. Didn't work, not even after making sure I included the space after the exclamation point. DRAT! Suggestions?

And yes, I do want this as a macro because it's only step 1 of 3 I eventually want the macro to perform.