Hello,
I would like to find and replace data in some column. Lets say in column C.
But i have some problem....
The data in this column which i have to pepcace may contain some aditional texts
For example :
I would like to replace .ACD with .ABC
in come cells .ACD have aditional texts .ADC Bookmark For You.
Is it possible to replace whole cell which Begins with .ADC with .ABC??

I wrote this script but it doesnot work

Sub Replace()

Range("C").Replace What:=".ACD '*', Replacement:=".ABC"
End Sub