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
Comparing two columns and returning value from another column 1
compare 5 columns of text and highlight duplicates based on repeti 2
compare columns return first duplicate only 0
Compare columns pull unique values and first duplicate value 0
Macro or formula to compare columns and give a result of the odd o 2
Compare 2 columns and choose one and enter answer in third column 1

Top