I have long text lists that require certain values to be removed but it may not be the entire value of the cell. So As I'm searching for let's say ".ht" I can replace all values with "%%%%%%%%%%%%%%%%%%" but I want a macro that says any cell containing "%%%%" gets deleted (the whole cell not just the %'s). This should be possible, no? How would I perform such a task.
Bookmarks