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.
![]()
Set rng = ActiveSheet.UsedRange rng.Replace what:="(", replacement:="" rng.Replace what:=")", replacement:="-"
Any ideas?
Bookmarks