I have a spreadsheet with three columns.
Column A contains a couple thousand lines of text.
Column B contains a list of values to search for in Column A
Column C contains a list of values to replace found values
I want to search the entire column a for values in "column B" and replace with corresponding value in "column C". for example, search column A for values in B1 and replace all matches with the value in C1, and continue until all lines of text in column A have been examined. Then do the same for the old/new pair B2/C2, then B3/C3, etc right down the list. Column A may contain multiple instances of matches for any given value in column B.
Note: This action does not replace the entire "column A" cell value, only the matching text within that cell.
For example, if one line somewhere in "Column A" reads "The fox ran away from the mouse" and cell B1= fox and cell C1= dog, the resulting value for that line in "Column A" would be "The dog ran away from the mouse", as the word "fox" was replaced by the word "dog".
Any Idea how I could accomplish this?
Bookmarks