Multiple Find and Replace

**karpal5** · 05-18-2011, 05:23 PM

I have to find a way to do a multiple find and replace for a project at work.

I have one excel file with a customer name and a unique ID number. I need to replace that unique ID number with their social security number. I have another excel sheet that shows unique ID number and the corresponding social security number. How do I program something so it will look for the id number and replace with the corresponding SSN from the second excel file?

Thanks for your help. I haven't done a ton of excel programming so patience is appreciated!

**TMS** · 05-18-2011, 06:08 PM

Add a Helper column. In that column put a VLOOKUP formula to pick up the SSN.

Copy the Helper column and Paste Special | Values over the original ID.

Delete the Helper column

Done

Regards

**JBeaucaire** · 05-18-2011, 06:08 PM

MASS REPLACE
Here's a macro for searching for a series of values/strings and replacing them with a new set of values/strings:
Mass Replace

To use the macro as is: