find and replace specific characters

This replace only seems to work when it mataches an entire cell value, but i simply want to replace specific characters, like ', or ) or (, located withing cells, anywhere on the sheet, it doesn't replace.

Please Login or Register  to view this content.

Any ideas?

Thank you... this is causing everything in those cells to be removed.

If it makes a difference, there's a lot going on in this macro... here's the whole thing:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This worked perfectly.

Thank you forum!

Please Login or Register  to view this content.