View Full Version : Using a macro to find and replace terms in specific column using an array of terms

08-10-2016, 10:02 AM
I want to use a macro to find and replace a list of terms with another list of terms in one column or in some instances just delete terms. The example below shows the original column and what I want the new column to contain.

Original New

Alabama Pickles Alabama Cucumbers

Utah - Trees Utah

Big UT Trees Big Trees