P
proton
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
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