Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and replace macro | Excel Discussion (Misc queries) | |||
Find & Replace and Find & Insert macro help needed | Excel Programming | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace Macro | Excel Programming | |||
Using Find and Replace to replace " in a macro | Excel Programming |