Compare 2 columns and delete duplicate text
 

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

Compare 2 columns and delete duplicate text
 

Hi,
See CPearson Web look for Delete duplicate rows, passing the middle of the
page

http://www.cpearson.com/excel/deleting.htm



"MF" wrote:

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