Sorry,
I should have been more clear. I am replacing occurances of text
within other text (like paragraphs). So if the cell contains:
"Every morning, Mr. Jones smells his tulips" and another cell
contains something else Mr. Jones does, and I want to make all
instances of Mr. Jones turn to Mr. Johnson, how do I do that? Do
I have to extract the whole cell and then search on it and put it
back?
Thanks for your help!
/mark