View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James[_48_] James[_48_] is offline
external usenet poster
 
Posts: 6
Default Find And replace macro

Could someone possibly send me the code that could accomplish the following in Sheet1?

1. Column A, titled "Phrase" contains 500 or more alphanumeric Strings
2. Column B, titled "Find and Delete" contains a single word or phrase (i.e., different phrases throughout the column)


The macro would go row by row, essentially Finding the values that are in Column B and, if it finds a match, it would delete that word or phrase from Column A.

In the example below, the values "Apple" and "Big" would be left remaining in column A, after the macro runs.

(A1)Phrase (B1)Find and Delete
(A2)Apple Jack (B2) Jack
(A3)Big Bug (B3) Bug

Thanks very much for any assistance.