Compare 2 columns and delete duplicate text

  • Thread starter Thread starter MF
  • Start date Start date
M

MF

I need to compare a column of 50,000 terms against a column of the 50 states
to remove any state names from the terms. Is this a formula or macros? How
would it be accomplished?

Ex.

Terms:

Furniture
Chairs Idaho
Desks
Desks in Alabama
Waterbeds
Florida Waterbed Store

State list (to remove):
Alabama
Arizona
Arkansas....
 
Back
Top