Compare 2 columns and delete duplicate text

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Data From One Column into Multiple Columns 2
Complex copy and paste in excel 5
Return US State Name or Territory from USPS Abbrevation - an example 3
Trying to check 2 columns for text and add a 3rd col to total 1
Delete Duplicate Names in Excel (Clear Text) 10
VB, implementing the high score within this code 1
Asp.net Important Topics. 0
[Text Editors] Comparison 120

Top