View Single Post
 
Old 01-22-2023, 01:27 AM
mrbolty mrbolty is offline Windows 11 Office 2019
Novice
 
Join Date: Jan 2023
Posts: 2
mrbolty is on a distinguished road
Question vba macro to remove wildcard patterns and replace with static

Hi

I can't seem to make this work, i simply want to have a button in word that will run a macro to remove preset, wildcard, pattern of text and replace them with a single word

There will be multiple patterns but a single replaced word in every case

For example

find a number starting with 012 and being 10 characters long and replace with REMOVED
find an email address and replace with REMOVED

Each time having an iterative list thus of things to find but always replacing with a static text.

I tried a find string but i'm struggling with the wildcard aspect, could anyone help with an example please?

Thanks

RC
Reply With Quote