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
