F
fjs20000
Is there some code that would accomplish the following:
In column A I have a large list (i.e., 50,000+ rows) of alphanumeric text that I need to clean. In column B, I have a series of phrases that I want touse 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 phrase that I want to remove from all cells in Column A via the Find and Replace function (i.e., I want to find "used parts" and replace it with nothing 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 individual phrases in column B.
Ideally, I can reuse the file to copy and paste large portions of data in column A, and also change the phrases (and numbers of phrases) in column B.
I tried to use the Record Macro option, but the macro was too large.
Thanks for any suggestions, or available code that would accomplish this!
In column A I have a large list (i.e., 50,000+ rows) of alphanumeric text that I need to clean. In column B, I have a series of phrases that I want touse 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 phrase that I want to remove from all cells in Column A via the Find and Replace function (i.e., I want to find "used parts" and replace it with nothing 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 individual phrases in column B.
Ideally, I can reuse the file to copy and paste large portions of data in column A, and also change the phrases (and numbers of phrases) in column B.
I tried to use the Record Macro option, but the macro was too large.
Thanks for any suggestions, or available code that would accomplish this!