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....