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