Code to do a simple clean of one column by copying and pasting (finding and replacing) phrases in adjacent column

Giganews Newsgroups
Subject: Code to do a simple clean of one column by copying and pasting (finding and replacing) phrases in adjacent column
Posted by:  fjs200…@gmail.com
Date: Wed, 28 May 2014

Is there some code that would accomplish the following:=20

In column A I have a large list (i.e., 50,000+ rows) of alphanumeric text t=
hat I need to clean. In column B, I have a series of phrases that I want to=
use to do a Find and Replace with a Blank for each of the cells in column =
A. So, for example, in cell B2, I have the phrase "used parts". That is a p=
hrase that I want to remove from all cells in Column A via the Find and Rep=
lace function (i.e., I want to find "used parts" and replace it with nothin=
g in all cells in column A). Then, I want to move down to cell B3, then B4,=
etc and keep repeating the process of cleaning column A with the individua=
l phrases in column B.=20

Ideally, I can reuse the file to copy and paste large portions of data in c=
olumn A, and also change the phrases (and numbers of phrases) in column B.=
=20

I tried to use the Record Macro option, but the macro was too large.=20

Thanks for any suggestions, or available code that would accomplish this!

Replies