There is a 'Replace All' button in 'Find and Replace' window (CTRL+H) right?
doesn't this work?

-kc
*Click YES if this helps

"watermt" wrote:

I have a lot of comments in a worksheet and have been requested to replace
one word in each of the comments with another word. Is there a way to
replace all occurences of the word without opening each and every comment one
at a time?