View Single Post
 
Old 08-28-2014, 07:28 AM
caj1980 caj1980 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2014
Posts: 6
caj1980 is on a distinguished road
Default Macro to replace SSN in all files within a folder

I am looking for help creating a macro that will replace all social security numbers in each document in a folder. Search string would be "???-??-" to be replaced with "XXX-XX-" so that we keep the last 4 of the SSN. I need to be able to run the macro against a folder of multiple documents with each document containing multiple instances of the SSN to be replaced. I have found some solutions on-line in various places but this is all new to me. I am not a programmer! We currently spend about 2 hours a day manually replacing all of the SSN's in each document.

THANK YOU SO MUCH!!!
Reply With Quote