Hi, I am looking for a macro solution to multiple search and replaces.

I have two columns of region names

column 1 ------------------------------------------------------ column 2

New York New York ---------------------------------------- New York-Jersey City-White Plains
SAN FRANSISCO SAN FRANSISCO COUNTY ------------ San Francisco-Redwood City-South San Francisco
IRVING DALLAS -------------------------------------------- Dallas-Plano-Irving

I need these names to be the same. What I would like to do is to search column one for values in column 2, and then replace the entire content of cells in column one with the entire content of cells in column two. For example: search column one for any cell that contains New York, Jersey City, or White Plains, and then replace the entire content of the column 1 cell with New York-Jersey City-White Plains. Then move on to the row below. I know this can be done for simple search and replace. What makes it harder is that I don't want to do a simple find a replace. I am hoping that there is some kind of "or" function in macros that lets you search for New York OR Jersey City OR White Plains based on just the one cell, and then replace the entire contents of the cell that has those values. Any solutions would be welcomed.

****Another problem is that city names appear in different states, for example Manhattan ny and Manhattan Kansas. I also have columns of states next to each column 1 and column two. If there is anyway to qualify the search and replace so that it only search for values when the states match, that would be very helpful. However, this is less important to me right now.

Thank you. Will