Hi Pros,
I have a spreadsheet that has data in 2x separate columns (around 150 rows long), named "range1" and "range2". The data in "range1" (Col A) might contain the text "xxx", in which case I want to replace with the text in the coresponding "range2" (Col F). I know that i can probably write code using For Next function to run down the column and make the replacements, but have been trying to use the bulk replace function instead to simply the overall code. Alas, not having much luck! Is this possible to achieve? Here is a sample of the (wrong) code that I am trying to write....... Thanks.
Bookmarks