In Sheet 2, I have a table (2 columns: A and B). In column A, I have listed the search items; in column B, I have listed the replace items.
I want to search all the items in Sheet 1 (say Column B) that corresponds to the column A values in Sheet2, and if it is found, replace them with the terms in column B.
To illustrate, in Sheet Column A, I have the terms delta, beta and alpha. I want to search these terms in Sheet1 Column B and if it is a hit, replace those terms in Sheet2 Column B, notably, ~d for Delta, ~b for Beta and ~a for Alpha. So the result would be,
Original: (Sheet1) Column B
The river flowed from its source to the delta where it entered the sea.
Modified: (Sheet1) Column B
The river flowed from its source to the ~d where it entered the sea.
Anyone got ideas?
I want to search all the items in Sheet 1 (say Column B) that corresponds to the column A values in Sheet2, and if it is found, replace them with the terms in column B.
To illustrate, in Sheet Column A, I have the terms delta, beta and alpha. I want to search these terms in Sheet1 Column B and if it is a hit, replace those terms in Sheet2 Column B, notably, ~d for Delta, ~b for Beta and ~a for Alpha. So the result would be,
Original: (Sheet1) Column B
The river flowed from its source to the delta where it entered the sea.
Modified: (Sheet1) Column B
The river flowed from its source to the ~d where it entered the sea.
Anyone got ideas?
