+ Reply to Thread
Results 1 to 3 of 3

Multiple Find and Replace

  1. #1
    Registered User
    Join Date
    05-18-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    1

    Multiple Find and Replace

    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!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,241

    Re: Multiple Find and Replace

    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

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Multiple Find and Replace

    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:
    1. create a new sheet called Categories
    2. put the values to find in column A
    3. put the replacement values in column B
    4. name your sheet sheet to search Data
    5. run the macro

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1