Find and Replace that contains some word

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

Sub NewReplace()
Range("C:C").Replace What:=".ACD", Replacement:=".ABC", lookat:=xlPart
End Sub

Or

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

Not sure which you wanted - try them on copies of your data.....

HTH,
Bernie
MS Excel MVP


"proton" <proton.2ckzs3_1155645008.5635@excelforum-nospam.com> wrote in message
news:proton.2ckzs3_1155645008.5635@excelforum-nospam.com...
>
> 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
>
>
> --
> proton
> ------------------------------------------------------------------------
> proton's Profile: http://www.excelforum.com/member.php...o&userid=36802
> View this thread: http://www.excelforum.com/showthread...hreadid=571739
>

10xs a lot
Its working