Hello, I have found this sample that I have attached here that seems to do what I am looking for, but I am unable to change the Array nor copy and paste down.
How is that done?
In column A is the original data. I need to be able to change/replace words in column A all the way down to about 5K rows
In Column B are the words I want to remove,
in column C I would input replacement words, or leave it Blank if no none are required
In column D would be the Final output as wished.
How can I change the current array to perform the task for all the data in column A?
In the current status it only works for the first 9 Rows in column A and can only find whats written in the first 3 Rows of Column B.
This is the code in the module of the attachment
Thank you for your inputHTML Code:
OP
Bookmarks