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.

Example: Column a Column B Column
C
-------------------------- ---------
---------
The wild fox jumps fox
dog
The cat ate the mouse cat owl
The bear saw the fox bear
deer
The cat ran from the fox
The piano played

Should produce this output:

The wild dog jumps
The owl ate the mouse
The deer saw the dog
The owl ran from the dog
The piano played

Any Idea how I could accomplish this?


--
Bucyruss
------------------------------------------------------------------------
Bucyruss's Profile: http://www.excelforum.com/member.php...o&userid=12070
View this thread: http://www.excelforum.com/showthread...hreadid=561521